APPS.GMS_POR_API2 dependencies on GMS_DISTRIBUTIONS

Line 67: FROM gms_distributions awd

63: FROM DUAL;
64:
65: CURSOR c_awd_dist_status IS
66: SELECT awd.dist_status
67: FROM gms_distributions awd
68: WHERE awd.document_distribution_id = l_distribution_id
69: AND awd.document_header_id = l_doc_header_id
70: AND awd.document_type = l_document_source
71: AND awd.dist_status <>'FABA';

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

180: END IF ;
181:
182: --Added debug messages for the bug 12901042
183: IF g_debug = 'Y' THEN
184: gms_error_pkg.gms_debug (g_error_procedure_name||' Inserting records in gms_distributions','C');
185: END IF;
186: --End for the bug 12901042
187:
188: --===========================================

Line 191: INSERT INTO gms_distributions

187:
188: --===========================================
189: -- Insert Records into gms_distribution table
190: --===========================================
191: INSERT INTO gms_distributions
192: ( document_header_id ,
193: document_distribution_id,
194: document_type,
195: gl_date,

Line 249: gms_distributions awd,

245: l_award_qty_obj.award_id,
246: l_award_qty_obj.quantity,
247: l_award_qty_obj.amount
248: FROM gms_distribution_details awdd,
249: gms_distributions awd,
250: gms_awards_all a
251: WHERE awd.document_distribution_id = awdd.document_distribution_id
252: AND awd.document_header_id = awdd.document_header_id
253: AND awd.document_distribution_id = l_distribution_id