944: l_trx_header_rec.issuer_name := l_values(22);
945: l_trx_header_rec.reviewer_name := l_values(23);
946: l_trx_header_rec.payee_name := l_values(24);
947: l_trx_header_rec.LATEST_VERSION_FLAG :='Y';
948: l_trx_header_rec.request_id := fnd_global.CONC_REQUEST_ID;
949: l_trx_header_rec.program_application_id
950: := fnd_global.RESP_APPL_ID;
951: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_ID;
952: l_trx_header_rec.program_update_date:= SYSDATE;
946: l_trx_header_rec.payee_name := l_values(24);
947: l_trx_header_rec.LATEST_VERSION_FLAG :='Y';
948: l_trx_header_rec.request_id := fnd_global.CONC_REQUEST_ID;
949: l_trx_header_rec.program_application_id
950: := fnd_global.RESP_APPL_ID;
951: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_ID;
952: l_trx_header_rec.program_update_date:= SYSDATE;
953: l_trx_header_rec.creation_date := SYSDATE;
954: l_trx_header_rec.created_by := fnd_global.USER_ID;
947: l_trx_header_rec.LATEST_VERSION_FLAG :='Y';
948: l_trx_header_rec.request_id := fnd_global.CONC_REQUEST_ID;
949: l_trx_header_rec.program_application_id
950: := fnd_global.RESP_APPL_ID;
951: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_ID;
952: l_trx_header_rec.program_update_date:= SYSDATE;
953: l_trx_header_rec.creation_date := SYSDATE;
954: l_trx_header_rec.created_by := fnd_global.USER_ID;
955: l_trx_header_rec.last_update_date := SYSDATE;
950: := fnd_global.RESP_APPL_ID;
951: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_ID;
952: l_trx_header_rec.program_update_date:= SYSDATE;
953: l_trx_header_rec.creation_date := SYSDATE;
954: l_trx_header_rec.created_by := fnd_global.USER_ID;
955: l_trx_header_rec.last_update_date := SYSDATE;
956: l_trx_header_rec.last_updated_by := fnd_global.USER_ID;
957: l_trx_header_rec.last_update_login := fnd_global.LOGIN_ID;
958: l_trx_header_rec.invoice_type := l_values(3); --added by subba
952: l_trx_header_rec.program_update_date:= SYSDATE;
953: l_trx_header_rec.creation_date := SYSDATE;
954: l_trx_header_rec.created_by := fnd_global.USER_ID;
955: l_trx_header_rec.last_update_date := SYSDATE;
956: l_trx_header_rec.last_updated_by := fnd_global.USER_ID;
957: l_trx_header_rec.last_update_login := fnd_global.LOGIN_ID;
958: l_trx_header_rec.invoice_type := l_values(3); --added by subba
959:
960:
953: l_trx_header_rec.creation_date := SYSDATE;
954: l_trx_header_rec.created_by := fnd_global.USER_ID;
955: l_trx_header_rec.last_update_date := SYSDATE;
956: l_trx_header_rec.last_updated_by := fnd_global.USER_ID;
957: l_trx_header_rec.last_update_login := fnd_global.LOGIN_ID;
958: l_trx_header_rec.invoice_type := l_values(3); --added by subba
959:
960:
961:
1077: FROM dual;
1078:
1079: l_trx_line_rec.discount_flag:=l_values(1);
1080: l_trx_line_rec.enabled_flag :='Y';
1081: l_trx_line_rec.request_id := fnd_global.CONC_REQUEST_ID;
1082: l_trx_line_rec.program_id := fnd_global.CONC_PROGRAM_ID;
1083: l_trx_line_rec.creation_date:= SYSDATE;
1084: l_trx_line_rec.created_by := fnd_global.USER_ID;
1085: l_trx_line_rec.last_update_date := SYSDATE;
1078:
1079: l_trx_line_rec.discount_flag:=l_values(1);
1080: l_trx_line_rec.enabled_flag :='Y';
1081: l_trx_line_rec.request_id := fnd_global.CONC_REQUEST_ID;
1082: l_trx_line_rec.program_id := fnd_global.CONC_PROGRAM_ID;
1083: l_trx_line_rec.creation_date:= SYSDATE;
1084: l_trx_line_rec.created_by := fnd_global.USER_ID;
1085: l_trx_line_rec.last_update_date := SYSDATE;
1086: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;
1080: l_trx_line_rec.enabled_flag :='Y';
1081: l_trx_line_rec.request_id := fnd_global.CONC_REQUEST_ID;
1082: l_trx_line_rec.program_id := fnd_global.CONC_PROGRAM_ID;
1083: l_trx_line_rec.creation_date:= SYSDATE;
1084: l_trx_line_rec.created_by := fnd_global.USER_ID;
1085: l_trx_line_rec.last_update_date := SYSDATE;
1086: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;
1087: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_ID;
1088: l_trx_line_rec.program_applicaton_id
1082: l_trx_line_rec.program_id := fnd_global.CONC_PROGRAM_ID;
1083: l_trx_line_rec.creation_date:= SYSDATE;
1084: l_trx_line_rec.created_by := fnd_global.USER_ID;
1085: l_trx_line_rec.last_update_date := SYSDATE;
1086: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;
1087: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_ID;
1088: l_trx_line_rec.program_applicaton_id
1089: := fnd_global.RESP_APPL_ID;
1090: l_trx_line_rec.program_update_date := SYSDATE;
1083: l_trx_line_rec.creation_date:= SYSDATE;
1084: l_trx_line_rec.created_by := fnd_global.USER_ID;
1085: l_trx_line_rec.last_update_date := SYSDATE;
1086: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;
1087: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_ID;
1088: l_trx_line_rec.program_applicaton_id
1089: := fnd_global.RESP_APPL_ID;
1090: l_trx_line_rec.program_update_date := SYSDATE;
1091:
1085: l_trx_line_rec.last_update_date := SYSDATE;
1086: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;
1087: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_ID;
1088: l_trx_line_rec.program_applicaton_id
1089: := fnd_global.RESP_APPL_ID;
1090: l_trx_line_rec.program_update_date := SYSDATE;
1091:
1092: l_trx_line_tbl.EXTEND;
1093: l_trx_line_tbl(l_trx_line_tbl.LAST):=l_trx_line_rec;
1681: --fill request_id etc. to P_INVOICE;
1682: UPDATE ar_gta_trx_headers
1683: SET status='GENERATED'
1684: , gta_batch_number =p_batch_number
1685: , export_request_id =fnd_global.CONC_REQUEST_ID
1686: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1687: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1688: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1689: , PROGRAM_UPDATE_DATE =SYSDATE
1682: UPDATE ar_gta_trx_headers
1683: SET status='GENERATED'
1684: , gta_batch_number =p_batch_number
1685: , export_request_id =fnd_global.CONC_REQUEST_ID
1686: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1687: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1688: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1689: , PROGRAM_UPDATE_DATE =SYSDATE
1690: , LAST_UPDATE_DATE =SYSDATE
1683: SET status='GENERATED'
1684: , gta_batch_number =p_batch_number
1685: , export_request_id =fnd_global.CONC_REQUEST_ID
1686: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1687: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1688: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1689: , PROGRAM_UPDATE_DATE =SYSDATE
1690: , LAST_UPDATE_DATE =SYSDATE
1691: , LAST_UPDATED_BY =fnd_global.USER_ID
1684: , gta_batch_number =p_batch_number
1685: , export_request_id =fnd_global.CONC_REQUEST_ID
1686: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1687: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1688: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1689: , PROGRAM_UPDATE_DATE =SYSDATE
1690: , LAST_UPDATE_DATE =SYSDATE
1691: , LAST_UPDATED_BY =fnd_global.USER_ID
1692: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1687: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1688: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1689: , PROGRAM_UPDATE_DATE =SYSDATE
1690: , LAST_UPDATE_DATE =SYSDATE
1691: , LAST_UPDATED_BY =fnd_global.USER_ID
1692: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1693: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1694:
1695: ELSE -- x_success <> G_EXPORT_SUCC
1688: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1689: , PROGRAM_UPDATE_DATE =SYSDATE
1690: , LAST_UPDATE_DATE =SYSDATE
1691: , LAST_UPDATED_BY =fnd_global.USER_ID
1692: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1693: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1694:
1695: ELSE -- x_success <> G_EXPORT_SUCC
1696: x_output(2):=g_comment_delimiter||l_header_output;
1706: END LOOP;
1707: END IF ;
1708:
1709: UPDATE ar_gta_trx_headers
1710: SET export_request_id =fnd_global.CONC_REQUEST_ID
1711: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1712: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1713: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1714: , PROGRAM_UPDATE_DATE =SYSDATE
1707: END IF ;
1708:
1709: UPDATE ar_gta_trx_headers
1710: SET export_request_id =fnd_global.CONC_REQUEST_ID
1711: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1712: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1713: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1714: , PROGRAM_UPDATE_DATE =SYSDATE
1715: , LAST_UPDATE_DATE =SYSDATE
1708:
1709: UPDATE ar_gta_trx_headers
1710: SET export_request_id =fnd_global.CONC_REQUEST_ID
1711: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1712: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1713: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1714: , PROGRAM_UPDATE_DATE =SYSDATE
1715: , LAST_UPDATE_DATE =SYSDATE
1716: , LAST_UPDATED_BY =fnd_global.USER_ID
1709: UPDATE ar_gta_trx_headers
1710: SET export_request_id =fnd_global.CONC_REQUEST_ID
1711: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1712: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1713: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1714: , PROGRAM_UPDATE_DATE =SYSDATE
1715: , LAST_UPDATE_DATE =SYSDATE
1716: , LAST_UPDATED_BY =fnd_global.USER_ID
1717: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1712: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1713: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1714: , PROGRAM_UPDATE_DATE =SYSDATE
1715: , LAST_UPDATE_DATE =SYSDATE
1716: , LAST_UPDATED_BY =fnd_global.USER_ID
1717: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1718: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1719:
1720: END IF;-- x_success = G_EXPORT_SUCC
1713: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1714: , PROGRAM_UPDATE_DATE =SYSDATE
1715: , LAST_UPDATE_DATE =SYSDATE
1716: , LAST_UPDATED_BY =fnd_global.USER_ID
1717: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1718: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1719:
1720: END IF;-- x_success = G_EXPORT_SUCC
1721:
1719:
1720: END IF;-- x_success = G_EXPORT_SUCC
1721:
1722: UPDATE ar_gta_trx_lines
1723: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID
1724: , program_application_id =fnd_global.RESP_APPL_ID
1725: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1726: , PROGRAM_UPDATE_DATE =SYSDATE
1727: , LAST_UPDATE_DATE =SYSDATE
1720: END IF;-- x_success = G_EXPORT_SUCC
1721:
1722: UPDATE ar_gta_trx_lines
1723: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID
1724: , program_application_id =fnd_global.RESP_APPL_ID
1725: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1726: , PROGRAM_UPDATE_DATE =SYSDATE
1727: , LAST_UPDATE_DATE =SYSDATE
1728: , LAST_UPDATED_BY =fnd_global.USER_ID
1721:
1722: UPDATE ar_gta_trx_lines
1723: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID
1724: , program_application_id =fnd_global.RESP_APPL_ID
1725: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1726: , PROGRAM_UPDATE_DATE =SYSDATE
1727: , LAST_UPDATE_DATE =SYSDATE
1728: , LAST_UPDATED_BY =fnd_global.USER_ID
1729: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1724: , program_application_id =fnd_global.RESP_APPL_ID
1725: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1726: , PROGRAM_UPDATE_DATE =SYSDATE
1727: , LAST_UPDATE_DATE =SYSDATE
1728: , LAST_UPDATED_BY =fnd_global.USER_ID
1729: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1730: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id
1731: AND ENABLED_FLAG='Y';
1732:
1725: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1726: , PROGRAM_UPDATE_DATE =SYSDATE
1727: , LAST_UPDATE_DATE =SYSDATE
1728: , LAST_UPDATED_BY =fnd_global.USER_ID
1729: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1730: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id
1731: AND ENABLED_FLAG='Y';
1732:
1733: --log for debug