eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SWEEPER dependencies on PA_BC_COMMITMENTS_ALL

Line 985: --Insert into pa_bc_commitments_all if bc_commitment_id is null in pa_bc_packets

981: END IF;
982:
983: pa_funds_control_utils.print_message('Inserting Commitments');
984:
985: --Insert into pa_bc_commitments_all if bc_commitment_id is null in pa_bc_packets
986: FORALL k in l_PktIdTab.FIRST..l_PktIdTab.LAST
987: insert into pa_bc_commitments_all(
988: bc_commitment_id,
989: packet_id,

Line 987: insert into pa_bc_commitments_all(

983: pa_funds_control_utils.print_message('Inserting Commitments');
984:
985: --Insert into pa_bc_commitments_all if bc_commitment_id is null in pa_bc_packets
986: FORALL k in l_PktIdTab.FIRST..l_PktIdTab.LAST
987: insert into pa_bc_commitments_all(
988: bc_commitment_id,
989: packet_id,
990: project_id,
991: task_id,

Line 1131: from pa_bc_commitments_all

1127: and l_PktRlmiTab(k) is not null
1128: and l_PktBdgtVerTab(k) is not null
1129: and l_PktDocTypTab(k) in ('AP', 'PO', 'REQ', 'CC_P_CO', 'CC_C_CO', 'CC_P_PAY', 'CC_C_PAY')
1130: and not exists (select 'X'
1131: from pa_bc_commitments_all
1132: where document_type = l_PktDocTypTab(k)
1133: and l_PktDocTypTab(k) in ('AP', 'PO', 'REQ', 'CC_P_CO', 'CC_C_CO', 'CC_P_PAY', 'CC_C_PAY')
1134: and document_header_id = l_PktDocHeadTab(k)
1135: and (document_distribution_id = l_PktDocDistTab(k)

Line 1159: pa_funds_control_utils.print_message('Before update of pa_bc_commitments_all');

1155: pa_debug.g_err_stage := 'Log: Before Update of commitments';
1156: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1157: END IF;
1158:
1159: pa_funds_control_utils.print_message('Before update of pa_bc_commitments_all');
1160:
1161: --Update pa_bc_commitments_all if bc_commitment_id is not null
1162: FORALL j in l_PktIdTab.FIRST..l_PktIdTab.LAST
1163: UPDATE pa_bc_commitments_all pbc

Line 1161: --Update pa_bc_commitments_all if bc_commitment_id is not null

1157: END IF;
1158:
1159: pa_funds_control_utils.print_message('Before update of pa_bc_commitments_all');
1160:
1161: --Update pa_bc_commitments_all if bc_commitment_id is not null
1162: FORALL j in l_PktIdTab.FIRST..l_PktIdTab.LAST
1163: UPDATE pa_bc_commitments_all pbc
1164: SET pbc.packet_id = l_PktIdTab(j),
1165: pbc.top_task_id = l_PktTTaskTab(j),

Line 1163: UPDATE pa_bc_commitments_all pbc

1159: pa_funds_control_utils.print_message('Before update of pa_bc_commitments_all');
1160:
1161: --Update pa_bc_commitments_all if bc_commitment_id is not null
1162: FORALL j in l_PktIdTab.FIRST..l_PktIdTab.LAST
1163: UPDATE pa_bc_commitments_all pbc
1164: SET pbc.packet_id = l_PktIdTab(j),
1165: pbc.top_task_id = l_PktTTaskTab(j),
1166: pbc.parent_resource_id = l_PktParResTab(j),
1167: pbc.budget_version_id = l_PktBdgtVerTab(j),

Line 1205: from pa_bc_commitments_all pbc1

1201: pbc.document_line_id = l_PktDocLineIdTab(j))
1202: )
1203: and pbc.bc_packet_id = l_PktBcPktTab(j)
1204: and exists (select 'X'
1205: from pa_bc_commitments_all pbc1
1206: where pbc1.project_id = l_PktProjectTab(j)
1207: and pbc1.task_id = l_PktTaskTab(j)
1208: and pbc1.document_type = l_PktDocTypTab(j)
1209: and l_PktDocTypTab(j) in ('AP', 'PO', 'REQ', 'CC_P_CO', 'CC_C_CO', 'CC_P_PAY', 'CC_C_PAY')