APPS.PA_BC_COSTING dependencies on DUAL

Line 589: FROM dual;

585:
586: l_stage := 500;
587: SELECT gl_bc_packets_s.NEXTVAL
588: INTO g_packet_id
589: FROM dual;
590:
591: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':Packet_id is [' || TO_CHAR(g_packet_id) || ']' ;
592: IF P_DEBUG_MODE = 'Y' THEN
593: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);

Line 1119: FROM DUAL ;

1115: ,l_resmap_line_num(i)
1116: ,l_resmap_request_id(i)
1117: ,l_resmap_budget_version_id(i)
1118: ,NULL
1119: FROM DUAL ;
1120: l_stage := 170;
1121: l_debug_stage := l_stage||':'||'Num of Rows Inserted into ResTmpTable['||sql%Rowcount||']';
1122: print_msg(l_debug_mode,l_debug_stage);
1123:

Line 1706: FROM DUAL

1702: ,g_request_id
1703: ,l_pkt_reference1_Tab(i)
1704: ,l_pkt_reference2_Tab(i)
1705: ,l_pkt_reference3_Tab(i)
1706: FROM DUAL
1707: ;
1708:
1709: l_records_affected := SQL%ROWCOUNT;
1710:

Line 2719: FROM dual;

2715:
2716: l_stage := 500;
2717: SELECT gl_bc_packets_s.NEXTVAL
2718: INTO g_packet_id
2719: FROM dual;
2720:
2721: pa_debug.g_err_stage := TO_CHAR(l_stage) || ': Packet_id is [' || TO_CHAR(g_packet_id) || ']' ;
2722: IF P_DEBUG_MODE = 'Y' THEN
2723: pa_debug.write_file(l_proc_name || ': ' || pa_debug.g_err_stage);

Line 3396: FROM DUAL;

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
3399: RAISE;
3400: END;

Line 3475: FROM DUAL;

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;
3478: END;
3479:

Line 3670: FROM DUAL;

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;
3673: END;
3674: l_ins_document_type_tab(ins_rec) := 'PO';

Line 3717: FROM DUAL;

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;
3720: END;
3721: l_ins_document_type_tab(ins_rec) := 'EXP';

Line 3751: FROM DUAL;

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;
3754: END;
3755:

Line 3788: FROM DUAL;

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;
3791: END;
3792: l_ins_expenditure_type_tab(ins_rec) := l_txn_burden_exp_type_tab(sep_burden);

Line 3980: FROM DUAL

3976: ,l_ins_exp_item_id_tab(ins_rec)
3977: ,l_ins_document_dist_id_tab(ins_rec)
3978: -- Bug 5494476 : Actual flag should be 'A' for expenditures and 'E' for PO commitment relieving records.
3979: ,decode (l_ins_document_type_tab(ins_rec),'EXP','A','E')
3980: FROM DUAL
3981: WHERE l_ins_rejn_code_tab(ins_rec) IS NULL
3982: ;
3983: END IF; --l_ins_packet_id_tab.COUNT > 0
3984: