[Home] [Help]
479: l_msg_count NUMBER :=0;
480: l_message_data VARCHAR2(2000);
481: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
482:
483: quality_config GMD_QUALITY_CONFIG%ROWTYPE;
484:
485: l_non_accept_w_spec NUMBER(5);
486: l_non_accept_wo_spec NUMBER(5);
487: l_non_reject_w_spec NUMBER(5);
1412: BEGIN
1413: -- for composite result orgn_code is not shown and is null.
1414: IF l_organization_id IS NOT NULL AND l_reason_id IS NULL THEN
1415: SELECT transaction_reason_id INTO l_reason_id
1416: FROM GMD_QUALITY_CONFIG
1417: WHERE organization_id = l_organization_id ;
1418: END IF;
1419: EXCEPTION WHEN OTHERS THEN
1420: NULL;