APPS.FV_GEN_ARTRX_REIMB_PROC dependencies on DUAL

Line 944: FROM DUAL;

940:
941:
942: SELECT fv_gen_ar_trx_s.nextval
943: INTO g_trx_coll_hdr_id
944: FROM DUAL;
945:
946: g_coll_hdr_tbl(1).trx_header_id := g_trx_coll_hdr_id;
947: -- Use the prefix defined for Liquidate Advance in the
948: -- define Federal options Form. FV_OPERATING_UNITS_ALL

Line 952: FROM DUAL;

948: -- define Federal options Form. FV_OPERATING_UNITS_ALL
949:
950: SELECT g_liq_adv_prefix||fv_gen_coll_ar_trx_s.nextval
951: INTO g_coll_hdr_tbl(1).trx_number
952: FROM DUAL;
953:
954: fv_utility.log_mesg('Ar Transaction: '||g_coll_hdr_tbl(1).trx_number);
955:
956: --Transaction type defined for Liquidate Advance in the

Line 971: FROM DUAL;

967: IF (p_trx_type = 'REC' AND g_rec_hdr_tbl.COUNT = 0) THEN
968:
969: SELECT fv_gen_ar_trx_s.nextval
970: INTO g_trx_rec_hdr_id
971: FROM DUAL;
972:
973: g_rec_hdr_tbl(1).trx_header_id := g_trx_rec_hdr_id;
974:
975: --Use the prefix defined for Receivables Due in the

Line 980: FROM DUAL;

976: --define Federal options Form. FV_OPERATING_UNITS_ALL
977:
978: SELECT g_rec_due_prefix||fv_gen_rec_ar_trx_s.nextval
979: INTO g_rec_hdr_tbl(1).trx_number
980: FROM DUAL;
981:
982: fv_utility.log_mesg('Ar Transaction: '||g_rec_hdr_tbl(1).trx_number);
983:
984: --Transaction type defined for Receivables Due in the

Line 1015: FROM DUAL;

1011: g_coll_lines_tbl(i).trx_header_id := g_trx_coll_hdr_id;
1012:
1013: SELECT ra_customer_trx_lines_s.nextval
1014: INTO g_coll_lines_tbl(i).trx_line_id
1015: FROM DUAL;
1016:
1017: g_coll_lines_tbl(i).line_number := i;
1018: g_coll_lines_tbl(i).quantity_invoiced := p_amount;
1019: g_coll_lines_tbl(i).unit_selling_price := 1;

Line 1031: FROM DUAL;

1027: g_coll_dist_tbl(i).trx_header_id := g_coll_lines_tbl(i).trx_header_id;
1028:
1029: SELECT ra_cust_trx_line_gl_dist_s.nextval
1030: INTO g_coll_dist_tbl(i).trx_dist_id
1031: FROM DUAL;
1032:
1033: g_coll_dist_tbl(i).account_class := 'REV';
1034: g_coll_dist_tbl(i).code_combination_id :=
1035: get_ccid(p_agreement,

Line 1052: FROM DUAL;

1048: g_rec_lines_tbl(j).trx_header_id := g_trx_rec_hdr_id;
1049:
1050: SELECT ra_customer_trx_lines_s.nextval
1051: INTO g_rec_lines_tbl(j).trx_line_id
1052: FROM DUAL;
1053:
1054:
1055: g_rec_lines_tbl(j).line_number := j;
1056: --bug 8903169

Line 1073: FROM DUAL;

1069: g_rec_dist_tbl(j).trx_header_id := g_rec_lines_tbl(j).trx_header_id;
1070:
1071: SELECT ra_cust_trx_line_gl_dist_s.nextval
1072: INTO g_rec_dist_tbl(j).trx_dist_id
1073: FROM DUAL;
1074:
1075: --We need to get the ccid for the Revenue line of the reimbursable Agreement
1076: --Replace the natural Account with the NAcc in the Transaction Type defined
1077: