DBA Data[Home] [Help]

APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on FND_GLOBAL

Line 948: l_trx_header_rec.request_id := fnd_global.CONC_REQUEST_ID;

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;

Line 950: := fnd_global.RESP_APPL_ID;

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;

Line 951: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_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;

Line 954: l_trx_header_rec.created_by := fnd_global.USER_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;
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

Line 956: l_trx_header_rec.last_updated_by := fnd_global.USER_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
959:
960:

Line 957: l_trx_header_rec.last_update_login := fnd_global.LOGIN_ID;

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:

Line 1081: l_trx_line_rec.request_id := fnd_global.CONC_REQUEST_ID;

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;

Line 1082: l_trx_line_rec.program_id := fnd_global.CONC_PROGRAM_ID;

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;

Line 1084: l_trx_line_rec.created_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

Line 1086: l_trx_line_rec.last_updated_by := fnd_global.USER_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;

Line 1087: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_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;
1091:

Line 1089: := fnd_global.RESP_APPL_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:
1092: l_trx_line_tbl.EXTEND;
1093: l_trx_line_tbl(l_trx_line_tbl.LAST):=l_trx_line_rec;

Line 1685: , export_request_id =fnd_global.CONC_REQUEST_ID

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

Line 1686: , REQUEST_ID =fnd_global.CONC_REQUEST_ID

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

Line 1687: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID

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

Line 1688: , PROGRAM_ID =fnd_global.CONC_PROGRAM_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

Line 1691: , LAST_UPDATED_BY =fnd_global.USER_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

Line 1692: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_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
1696: x_output(2):=g_comment_delimiter||l_header_output;

Line 1710: SET export_request_id =fnd_global.CONC_REQUEST_ID

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

Line 1711: , REQUEST_ID =fnd_global.CONC_REQUEST_ID

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

Line 1712: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID

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

Line 1713: , PROGRAM_ID =fnd_global.CONC_PROGRAM_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

Line 1716: , LAST_UPDATED_BY =fnd_global.USER_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

Line 1717: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_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
1721:

Line 1723: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID

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

Line 1724: , program_application_id =fnd_global.RESP_APPL_ID

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

Line 1725: , PROGRAM_ID =fnd_global.CONC_PROGRAM_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

Line 1728: , LAST_UPDATED_BY =fnd_global.USER_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:

Line 1729: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_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:
1733: --log for debug