APPS.PA_BC_COSTING dependencies on PA_BC_PACKETS_S

Line 1690: ,pa_bc_packets_s.NEXTVAL -- bc_packet_id

1686: ,l_document_line_id_tab(i) -- document_line_id
1687: ,l_dr_code_combination_id_tab(i) -- txn_ccid
1688: ,l_acct_raw_cost_tab(i) -- accounted_dr
1689: ,l_acct_raw_cost_tab(i) -- entered_dr
1690: ,pa_bc_packets_s.NEXTVAL -- bc_packet_id
1691: ,l_parent_bc_packet_id_tab(i) -- parent_bc_packet_id
1692: ,l_org_id_tab(i) -- org_id
1693: ,'N' -- balance_posted_flag
1694: ,g_program_id -- program_id

Line 1817: ,pa_bc_packets_s.NEXTVAL -- pa_bc_packet_id

1813: ,l_document_line_id_tab(i) -- document_line_id
1814: ,l_dr_code_combination_id_tab(i) -- txn_ccid
1815: ,(l_acct_burdened_cost_tab(i) - l_acct_raw_cost_tab(i)) -- accounted_dr
1816: ,(l_acct_burdened_cost_tab(i) - l_acct_raw_cost_tab(i)) -- entered_dr
1817: ,pa_bc_packets_s.NEXTVAL -- pa_bc_packet_id
1818: --,DECODE(l_line_num_reversed_tab(i), NULL, NULL, bcpk.bc_packet_id) -- parent_bc_packet_id
1819: ,DECODE(l_line_type_tab(i), 'I', NULL, DECODE(l_line_num_reversed_tab(i), NULL, NULL, bcpk.bc_packet_id)) -- parent_bc_packet_id
1820: ,l_org_id_tab(i) -- org_id
1821: ,'N' -- balance_posted_flag

Line 1930: ,pa_bc_packets_s.NEXTVAL -- bc_packet_id

1926: ,l_document_line_id_tab(i) -- document_line_id
1927: ,l_dr_code_combination_id_tab(i) -- txn_ccid
1928: ,ROUND(l_acct_raw_cost_tab(i) * cm.compiled_multiplier,2) -- accounted_dr
1929: ,ROUND(l_acct_raw_cost_tab(i) * cm.compiled_multiplier,2) -- entered_dr
1930: ,pa_bc_packets_s.NEXTVAL -- bc_packet_id
1931: --,DECODE(l_line_num_reversed_tab(i), NULL, NULL, bcpk.bc_packet_id) -- parent_bc_packet_id
1932: ,DECODE(l_line_type_tab(i), 'I', NULL, DECODE(l_line_num_reversed_tab(i), NULL, NULL, bcpk.bc_packet_id)) -- parent_bc_packet_id
1933: ,l_org_id_tab(i) -- org_id
1934: ,'N' -- balance_posted_flag

Line 3394: SELECT pa_bc_packets_s.NEXTVAL

3390: l_ins_document_dist_id_tab(ins_rec) := -9999;
3391:
3392: BEGIN
3393: pa_debug.g_err_stage := 'ORACLE error selecting sequence';
3394: SELECT pa_bc_packets_s.NEXTVAL
3395: INTO l_ins_bc_packet_id_tab(ins_rec)
3396: FROM DUAL;
3397: EXCEPTION
3398: WHEN OTHERS THEN

Line 3473: SELECT pa_bc_packets_s.NEXTVAL

3469: +===========================================================*/
3470: l_ins_document_dist_id_tab(ins_rec) := -9999;
3471:
3472: BEGIN
3473: SELECT pa_bc_packets_s.NEXTVAL
3474: INTO l_ins_bc_packet_id_tab(ins_rec)
3475: FROM DUAL;
3476: EXCEPTION
3477: WHEN OTHERS THEN RAISE;

Line 3668: SELECT pa_bc_packets_s.NEXTVAL

3664: | on Prithi's advice. |
3665: +===========================================================*/
3666: l_ins_document_dist_id_tab(ins_rec) := -9999;
3667: BEGIN
3668: SELECT pa_bc_packets_s.NEXTVAL
3669: INTO l_ins_bc_packet_id_tab(ins_rec)
3670: FROM DUAL;
3671: EXCEPTION
3672: WHEN OTHERS THEN RAISE;

Line 3715: SELECT pa_bc_packets_s.NEXTVAL

3711: pa_debug.g_err_stage := 'Inserting raw EXP record ins_rec is [' || to_char(ins_rec) || ']';
3712: pa_debug.write_file(l_stage || pa_debug.g_err_stage);
3713: copy_common_attributes( i ,ins_rec );
3714: BEGIN
3715: SELECT pa_bc_packets_s.NEXTVAL
3716: INTO l_ins_bc_packet_id_tab(ins_rec)
3717: FROM DUAL;
3718: EXCEPTION
3719: WHEN OTHERS THEN RAISE;

Line 3749: SELECT pa_bc_packets_s.NEXTVAL

3745: pa_debug.g_err_stage := 'inserting burden same line exp record ins_rec is [' || to_char(ins_rec) || ']';
3746: pa_debug.write_file(l_stage || pa_debug.g_err_stage);
3747: copy_common_attributes( i ,ins_rec );
3748: BEGIN
3749: SELECT pa_bc_packets_s.NEXTVAL
3750: INTO l_ins_bc_packet_id_tab(ins_rec)
3751: FROM DUAL;
3752: EXCEPTION
3753: WHEN OTHERS THEN RAISE;

Line 3786: SELECT pa_bc_packets_s.NEXTVAL

3782: ins_rec := ins_rec + 1;
3783: pa_debug.write_file('inserting burden sep line exp record ins_rec is [' || to_char(ins_rec) || ']');
3784: copy_common_attributes( i ,ins_rec );
3785: BEGIN
3786: SELECT pa_bc_packets_s.NEXTVAL
3787: INTO l_ins_bc_packet_id_tab(ins_rec)
3788: FROM DUAL;
3789: EXCEPTION
3790: WHEN OTHERS THEN RAISE;