APPS.GMS_PA_API dependencies on GMS_BC_PACKETS

Line 1171: -- Bug 2143160 Insert vendor_id into gms_bc_packets for AP and EXP

1167: -- get_award_cmt_compiled_set_id was replaced by award_cmt_compiled_set_id
1168: -- ========================================================================================
1169:
1170: -- ---------------------------------------------------------------
1171: -- Bug 2143160 Insert vendor_id into gms_bc_packets for AP and EXP
1172: -- ---------------------------------------------------------------
1173:
1174: Insert into gms_bc_packets
1175: ( PACKET_ID,

Line 1174: Insert into gms_bc_packets

1170: -- ---------------------------------------------------------------
1171: -- Bug 2143160 Insert vendor_id into gms_bc_packets for AP and EXP
1172: -- ---------------------------------------------------------------
1173:
1174: Insert into gms_bc_packets
1175: ( PACKET_ID,
1176: PROJECT_ID,
1177: AWARD_ID,
1178: TASK_ID,

Line 1254: gms_bc_packets_s.nextval,

1250: gbc.OVERRIDE_AMOUNT,
1251: gbc.EFFECT_ON_FUNDS_CODE ,
1252: gbc.RESULT_CODE,
1253: gbc.gl_bc_packets_rowid,
1254: gms_bc_packets_s.nextval,
1255: gbc.BC_PACKET_ID,
1256: gbc.vendor_id
1257: from pa_ind_rate_sch_revisions irsr,
1258: pa_cost_bases cb,

Line 1265: gms_bc_packets gbc

1261: pa_cost_base_exp_types cbet,
1262: pa_ind_rate_schedules_all_bg irs,
1263: pa_ind_compiled_sets ics,
1264: pa_compiled_multipliers cm,
1265: gms_bc_packets gbc
1266: where irsr.cost_plus_structure = cbet.cost_plus_structure
1267: and cb.cost_base = cbet.cost_base
1268: and cb.cost_base_type = cbet.cost_base_type
1269: and ics.cost_base = cbet.cost_base --Bug 3003584

Line 1296: Insert into gms_bc_packets

1292:
1293: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1294: -- BUG: 1418038 Supplier invoice not updated properly in ASI and FC results .
1295: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1296: Insert into gms_bc_packets
1297: ( PACKET_ID,
1298: PROJECT_ID,
1299: AWARD_ID,
1300: TASK_ID,

Line 1376: gms_bc_packets_s.nextval,

1372: gbc.OVERRIDE_AMOUNT,
1373: gbc.EFFECT_ON_FUNDS_CODE ,
1374: gbc.RESULT_CODE,
1375: gbc.GL_BC_PACKETS_ROWID,
1376: gms_bc_packets_s.nextval,
1377: gbc.BC_PACKET_ID,
1378: gbc.vendor_id
1379: from pa_ind_rate_sch_revisions irsr,
1380: pa_cost_bases cb,

Line 1387: gms_bc_packets gbc

1383: pa_cost_base_exp_types cbet,
1384: pa_ind_rate_schedules_all_bg irs,
1385: pa_ind_compiled_sets ics,
1386: pa_compiled_multipliers cm,
1387: gms_bc_packets gbc
1388: where irsr.cost_plus_structure = cbet.cost_plus_structure
1389: and cb.cost_base = cbet.cost_base
1390: and cb.cost_base_type = cbet.cost_base_type
1391: and ics.cost_base = cbet.cost_base --Bug 3003584

Line 1450: WHERE exists ( select 'X' from gms_bc_packets

1446:
1447: SELECT count(*)
1448: into x_err_code
1449: FROM DUAL
1450: WHERE exists ( select 'X' from gms_bc_packets
1451: where packet_id = x_packet_id
1452: and substr(nvl(result_code, 'P'),1,1) = 'F' );
1453:
1454: IF L_DEBUG = 'Y' THEN

Line 1566: from gms_bc_packets

1562: and expenditure_type = x_exp_type ;
1563:
1564: cursor c_awd_exp_type_check2 ( x_award_id number, x_exp_type varchar2) is
1565: select 1
1566: from gms_bc_packets
1567: where status_code = 'A'
1568: and award_id = x_award_id
1569: and expenditure_type = x_exp_type ;
1570: