APPS.GMS_POR_API dependencies on GMS_DISTRIBUTIONS

Line 1356: FROM gms_distributions awd

1352: FROM DUAL;
1353:
1354: CURSOR c_awd_dist_status IS
1355: SELECT awd.dist_status
1356: FROM gms_distributions awd
1357: WHERE awd.document_distribution_id = l_distribution_id
1358: AND awd.document_header_id = l_doc_header_id
1359: AND awd.document_type = l_document_source
1360: AND awd.dist_status <>'FABA';

Line 1464: gms_error_pkg.gms_debug (g_error_procedure_name||' Inserting records in gms_distributions','C');

1460: END IF ;
1461:
1462: --Added debug messages for the bug 12901042
1463: IF g_debug = 'Y' THEN
1464: gms_error_pkg.gms_debug (g_error_procedure_name||' Inserting records in gms_distributions','C');
1465: END IF;
1466: --End for the bug 12901042
1467:
1468: --===========================================

Line 1471: INSERT INTO gms_distributions

1467:
1468: --===========================================
1469: -- Insert Records into gms_distribution table
1470: --===========================================
1471: INSERT INTO gms_distributions
1472: ( document_header_id ,
1473: document_distribution_id,
1474: document_type,
1475: gl_date,

Line 1527: gms_distributions awd,

1523: BULK COLLECT INTO l_award_qty_obj.award_num,
1524: l_award_qty_obj.award_id,
1525: l_award_qty_obj.quantity
1526: FROM gms_distribution_details awdd,
1527: gms_distributions awd,
1528: gms_awards_all a
1529: WHERE awd.document_distribution_id = awdd.document_distribution_id
1530: AND awd.document_header_id = awdd.document_header_id
1531: AND awd.document_distribution_id = l_distribution_id