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_INVOICE_DETAIL_PROCESS dependencies on PA_DRAFT_INVOICE_DETAILS

Line 151: SELECT pa_draft_invoice_details_s.nextval

147: IS
148: l_nextval NUMBER;
149: BEGIN
150:
151: SELECT pa_draft_invoice_details_s.nextval
152: INTO l_nextval
153: FROM SYS.DUAL;
154:
155: RETURN(l_nextval);

Line 693: PROCEDURE insert_row ( p_inv_rec IN OUT NOCOPY pa_draft_invoice_details%rowtype )

689: Raise;
690: END update_cc_dist;
691:
692: --Procedure to add record in insert buffer
693: PROCEDURE insert_row ( p_inv_rec IN OUT NOCOPY pa_draft_invoice_details%rowtype )
694: IS
695: BEGIN
696:
697: IF g1_debug_mode = 'Y' THEN

Line 710: PROCEDURE delete_row ( p_inv_rec IN pa_draft_invoice_details%rowtype )

706:
707: END insert_row;
708:
709: --Procedure to add record in delete buffer
710: PROCEDURE delete_row ( p_inv_rec IN pa_draft_invoice_details%rowtype )
711: IS
712: BEGIN
713:
714: IF g1_debug_mode = 'Y' THEN

Line 725: PROCEDURE update_row ( p_inv_rec IN pa_draft_invoice_details%rowtype,

721:
722: END delete_row;
723:
724: --Procedure to add record in update buffer
725: PROCEDURE update_row ( p_inv_rec IN pa_draft_invoice_details%rowtype,
726: p_mrc_required IN varchar2 )
727: IS
728: BEGIN
729:

Line 778: PROCEDURE reverse_row ( p_inv_rec IN OUT NOCOPY pa_draft_invoice_details%rowtype,

774:
775: --Procedure to add record in update buffer
776: /* Added the parameter p_adjusted_ei for bug 2770182 */
777:
778: PROCEDURE reverse_row ( p_inv_rec IN OUT NOCOPY pa_draft_invoice_details%rowtype,
779: p_adjusted_ei IN NUMBER default null )
780: IS
781: t_line_num NUMBER:=0;
782: BEGIN

Line 830: FROM pa_draft_invoice_details_all

826:
827: t_line_num :=0;
828:
829: SELECT max(line_num) INTO t_line_num
830: FROM pa_draft_invoice_details_all
831: WHERE expenditure_item_id = p_inv_rec.expenditure_item_id
832: AND draft_invoice_num IS NULL
833: AND DRAFT_INVOICE_LINE_NUM IS NULL
834: AND NVL(invoiced_flag,'N') ='N';

Line 870: P_Inv_rec IN OUT NOCOPY pa_draft_invoice_details%rowtype)

866: -- Procedure to build new row from existing row
867: Procedure build_row ( P_Mode IN Varchar2,
868: P_Arr_position IN number,
869: P_Rev_ccid IN number,
870: P_Inv_rec IN OUT NOCOPY pa_draft_invoice_details%rowtype)
871: IS
872: BEGIN
873: IF g1_debug_mode = 'Y' THEN
874: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.build_row1...');

Line 943: -- Build a fresh row for PA_DRAFT_INVOICE_DETAILS

939: Then
940: Raise;
941: END build_row;
942:
943: -- Build a fresh row for PA_DRAFT_INVOICE_DETAILS
944: Procedure build_row ( P_Expenditure_item_id IN number,
945: P_Project_Id IN number,
946: P_CC_Project_id IN number,
947: P_CC_Tax_task_id IN number,

Line 950: X_Inv_rec OUT NOCOPY pa_draft_invoice_details%rowtype)

946: P_CC_Project_id IN number,
947: P_CC_Tax_task_id IN number,
948: P_Rev_ccid IN number,
949: P_Arr_position IN number,
950: X_Inv_rec OUT NOCOPY pa_draft_invoice_details%rowtype)
951: IS
952: l_inv_rec pa_draft_invoice_details%rowtype;
953: c number :=0;
954: BEGIN

Line 952: l_inv_rec pa_draft_invoice_details%rowtype;

948: P_Rev_ccid IN number,
949: P_Arr_position IN number,
950: X_Inv_rec OUT NOCOPY pa_draft_invoice_details%rowtype)
951: IS
952: l_inv_rec pa_draft_invoice_details%rowtype;
953: c number :=0;
954: BEGIN
955: IF g1_debug_mode = 'Y' THEN
956: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.build_row2...');

Line 1013: /* Bug #1374381 Assigned the org_id for inert into pa_draft_invoice_details table*/

1009: l_inv_rec.tp_job_id := I_tp_job_id(P_Arr_position);
1010: l_inv_rec.prov_proj_bill_job_id := I_prov_proj_bill_job_id(P_Arr_position);
1011:
1012:
1013: /* Bug #1374381 Assigned the org_id for inert into pa_draft_invoice_details table*/
1014: l_inv_rec.org_id := PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID;
1015:
1016: /*Added for cross proj */
1017: l_inv_rec.tp_amt_type_code := I_tp_amt_type_code(P_Arr_position);

Line 1059: FUNCTION is_new_details(P_IND_REC IN pa_draft_invoice_details%rowtype,

1055:
1056: END add_ei;
1057:
1058: -- Function to check whether New invoice details to be created or not.
1059: FUNCTION is_new_details(P_IND_REC IN pa_draft_invoice_details%rowtype,
1060: P_Rev_ccid IN number,
1061: P_Index IN number)
1062: Return Boolean
1063: IS

Line 1112: OUT NOCOPY pa_draft_invoice_details%rowtype)

1108: -- Read the Original Invoice details for reversing invoice details.
1109: PROCEDURE read_orig(P_Expenditure_item_id IN Number,
1110: P_Line_num IN Number,
1111: X_IND_REC
1112: OUT NOCOPY pa_draft_invoice_details%rowtype)
1113: IS
1114: BEGIN
1115: IF g1_debug_mode = 'Y' THEN
1116: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.read_orig...');

Line 1120: FROM PA_DRAFT_INVOICE_DETAILS

1116: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.read_orig...');
1117: END IF;
1118: Select *
1119: INTO X_IND_REC
1120: FROM PA_DRAFT_INVOICE_DETAILS
1121: WHERE EXPENDITURE_ITEM_ID = P_Expenditure_item_id
1122: AND LINE_NUM = P_Line_num ;
1123: EXCEPTION
1124: WHEN Others

Line 1160: /* Apply Pending Delete/Update/Insert in PA_DRAFT_INVOICE Details */

1156:
1157: IF g1_debug_mode = 'Y' THEN
1158: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.apply_db_changes...');
1159: END IF;
1160: /* Apply Pending Delete/Update/Insert in PA_DRAFT_INVOICE Details */
1161: PA_INVOICE_DETAIL_PKG.delete_rows(P_Delete_tab);
1162: PA_INVOICE_DETAIL_PKG.update_rows(P_Update_tab,I_MRC_REQD_FLAG);
1163: PA_INVOICE_DETAIL_PKG.insert_rows(P_Insert_tab);
1164:

Line 1493: L_IND_REC pa_draft_invoice_details%rowtype;

1489: IS
1490:
1491: /** Local variable for SQL Fetch *******/
1492: /*Added L_IND_REC_NULL for bug 2296735 */
1493: L_IND_REC pa_draft_invoice_details%rowtype;
1494: L_IND_REC_NULL pa_draft_invoice_details%rowtype;
1495: L_IND_REC_NEW pa_draft_invoice_details%rowtype;
1496: X_Inv_rec pa_draft_invoice_details%rowtype;
1497: L_CC_REC get_cc_dist%rowtype;

Line 1494: L_IND_REC_NULL pa_draft_invoice_details%rowtype;

1490:
1491: /** Local variable for SQL Fetch *******/
1492: /*Added L_IND_REC_NULL for bug 2296735 */
1493: L_IND_REC pa_draft_invoice_details%rowtype;
1494: L_IND_REC_NULL pa_draft_invoice_details%rowtype;
1495: L_IND_REC_NEW pa_draft_invoice_details%rowtype;
1496: X_Inv_rec pa_draft_invoice_details%rowtype;
1497: L_CC_REC get_cc_dist%rowtype;
1498: L_CDL_REC prv_class_rec;

Line 1495: L_IND_REC_NEW pa_draft_invoice_details%rowtype;

1491: /** Local variable for SQL Fetch *******/
1492: /*Added L_IND_REC_NULL for bug 2296735 */
1493: L_IND_REC pa_draft_invoice_details%rowtype;
1494: L_IND_REC_NULL pa_draft_invoice_details%rowtype;
1495: L_IND_REC_NEW pa_draft_invoice_details%rowtype;
1496: X_Inv_rec pa_draft_invoice_details%rowtype;
1497: L_CC_REC get_cc_dist%rowtype;
1498: L_CDL_REC prv_class_rec;
1499: L_Compute_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 1496: X_Inv_rec pa_draft_invoice_details%rowtype;

1492: /*Added L_IND_REC_NULL for bug 2296735 */
1493: L_IND_REC pa_draft_invoice_details%rowtype;
1494: L_IND_REC_NULL pa_draft_invoice_details%rowtype;
1495: L_IND_REC_NEW pa_draft_invoice_details%rowtype;
1496: X_Inv_rec pa_draft_invoice_details%rowtype;
1497: L_CC_REC get_cc_dist%rowtype;
1498: L_CDL_REC prv_class_rec;
1499: L_Compute_flag PA_PLSQL_DATATYPES.Char1TabTyp;
1500: L_AdjEI_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 1892: FROM PA_DRAFT_INVOICE_DETAILS DET

1888: PA_IC_INV_UTILS.log_message('process_invoice_details: ' || 'Fetching Existing Invoice details for EI'||to_char(P_EI_ID(I)));
1889: END IF;
1890: SELECT DET.*
1891: INTO L_IND_REC
1892: FROM PA_DRAFT_INVOICE_DETAILS DET
1893: WHERE DET.EXPENDITURE_ITEM_ID
1894: = decode(nvl(P_AdjEI_id(I),0),0,P_EI_id(I),P_AdjEI_id(I))
1895: AND DET.LINE_NUM = ( SELECT MAX(I.LINE_NUM)
1896: FROM PA_DRAFT_INVOICE_DETAILS I

Line 1896: FROM PA_DRAFT_INVOICE_DETAILS I

1892: FROM PA_DRAFT_INVOICE_DETAILS DET
1893: WHERE DET.EXPENDITURE_ITEM_ID
1894: = decode(nvl(P_AdjEI_id(I),0),0,P_EI_id(I),P_AdjEI_id(I))
1895: AND DET.LINE_NUM = ( SELECT MAX(I.LINE_NUM)
1896: FROM PA_DRAFT_INVOICE_DETAILS I
1897: WHERE I.EXPENDITURE_ITEM_ID =
1898: DET.EXPENDITURE_ITEM_ID );
1899: RECORD_FOUND := TRUE;
1900: I_Line_num := L_IND_REC.Line_Num;