DBA Data[Home] [Help]

APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on FND_GLOBAL

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

835: l_trx_header_rec.issuer_name := l_values(22);
836: l_trx_header_rec.reviewer_name := l_values(23);
837: l_trx_header_rec.payee_name := l_values(24);
838: l_trx_header_rec.LATEST_VERSION_FLAG :='Y';
839: l_trx_header_rec.request_id := fnd_global.CONC_REQUEST_ID;
840: l_trx_header_rec.program_application_id
841: := fnd_global.RESP_APPL_ID;
842: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_ID;
843: l_trx_header_rec.program_update_date:= SYSDATE;

Line 841: := fnd_global.RESP_APPL_ID;

837: l_trx_header_rec.payee_name := l_values(24);
838: l_trx_header_rec.LATEST_VERSION_FLAG :='Y';
839: l_trx_header_rec.request_id := fnd_global.CONC_REQUEST_ID;
840: l_trx_header_rec.program_application_id
841: := fnd_global.RESP_APPL_ID;
842: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_ID;
843: l_trx_header_rec.program_update_date:= SYSDATE;
844: l_trx_header_rec.creation_date := SYSDATE;
845: l_trx_header_rec.created_by := fnd_global.USER_ID;

Line 842: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_ID;

838: l_trx_header_rec.LATEST_VERSION_FLAG :='Y';
839: l_trx_header_rec.request_id := fnd_global.CONC_REQUEST_ID;
840: l_trx_header_rec.program_application_id
841: := fnd_global.RESP_APPL_ID;
842: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_ID;
843: l_trx_header_rec.program_update_date:= SYSDATE;
844: l_trx_header_rec.creation_date := SYSDATE;
845: l_trx_header_rec.created_by := fnd_global.USER_ID;
846: l_trx_header_rec.last_update_date := SYSDATE;

Line 845: l_trx_header_rec.created_by := fnd_global.USER_ID;

841: := fnd_global.RESP_APPL_ID;
842: l_trx_header_rec.program_id := fnd_global.CONC_PROGRAM_ID;
843: l_trx_header_rec.program_update_date:= SYSDATE;
844: l_trx_header_rec.creation_date := SYSDATE;
845: l_trx_header_rec.created_by := fnd_global.USER_ID;
846: l_trx_header_rec.last_update_date := SYSDATE;
847: l_trx_header_rec.last_updated_by := fnd_global.USER_ID;
848: l_trx_header_rec.last_update_login := fnd_global.LOGIN_ID;
849: l_trx_header_rec.invoice_type := l_values(3); --added by subba

Line 847: l_trx_header_rec.last_updated_by := fnd_global.USER_ID;

843: l_trx_header_rec.program_update_date:= SYSDATE;
844: l_trx_header_rec.creation_date := SYSDATE;
845: l_trx_header_rec.created_by := fnd_global.USER_ID;
846: l_trx_header_rec.last_update_date := SYSDATE;
847: l_trx_header_rec.last_updated_by := fnd_global.USER_ID;
848: l_trx_header_rec.last_update_login := fnd_global.LOGIN_ID;
849: l_trx_header_rec.invoice_type := l_values(3); --added by subba
850:
851:

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

844: l_trx_header_rec.creation_date := SYSDATE;
845: l_trx_header_rec.created_by := fnd_global.USER_ID;
846: l_trx_header_rec.last_update_date := SYSDATE;
847: l_trx_header_rec.last_updated_by := fnd_global.USER_ID;
848: l_trx_header_rec.last_update_login := fnd_global.LOGIN_ID;
849: l_trx_header_rec.invoice_type := l_values(3); --added by subba
850:
851:
852:

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

968: FROM dual;
969:
970: l_trx_line_rec.discount_flag:=l_values(1);
971: l_trx_line_rec.enabled_flag :='Y';
972: l_trx_line_rec.request_id := fnd_global.CONC_REQUEST_ID;
973: l_trx_line_rec.program_id := fnd_global.CONC_PROGRAM_ID;
974: l_trx_line_rec.creation_date:= SYSDATE;
975: l_trx_line_rec.created_by := fnd_global.USER_ID;
976: l_trx_line_rec.last_update_date := SYSDATE;

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

969:
970: l_trx_line_rec.discount_flag:=l_values(1);
971: l_trx_line_rec.enabled_flag :='Y';
972: l_trx_line_rec.request_id := fnd_global.CONC_REQUEST_ID;
973: l_trx_line_rec.program_id := fnd_global.CONC_PROGRAM_ID;
974: l_trx_line_rec.creation_date:= SYSDATE;
975: l_trx_line_rec.created_by := fnd_global.USER_ID;
976: l_trx_line_rec.last_update_date := SYSDATE;
977: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;

Line 975: l_trx_line_rec.created_by := fnd_global.USER_ID;

971: l_trx_line_rec.enabled_flag :='Y';
972: l_trx_line_rec.request_id := fnd_global.CONC_REQUEST_ID;
973: l_trx_line_rec.program_id := fnd_global.CONC_PROGRAM_ID;
974: l_trx_line_rec.creation_date:= SYSDATE;
975: l_trx_line_rec.created_by := fnd_global.USER_ID;
976: l_trx_line_rec.last_update_date := SYSDATE;
977: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;
978: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_ID;
979: l_trx_line_rec.program_applicaton_id

Line 977: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;

973: l_trx_line_rec.program_id := fnd_global.CONC_PROGRAM_ID;
974: l_trx_line_rec.creation_date:= SYSDATE;
975: l_trx_line_rec.created_by := fnd_global.USER_ID;
976: l_trx_line_rec.last_update_date := SYSDATE;
977: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;
978: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_ID;
979: l_trx_line_rec.program_applicaton_id
980: := fnd_global.RESP_APPL_ID;
981: l_trx_line_rec.program_update_date := SYSDATE;

Line 978: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_ID;

974: l_trx_line_rec.creation_date:= SYSDATE;
975: l_trx_line_rec.created_by := fnd_global.USER_ID;
976: l_trx_line_rec.last_update_date := SYSDATE;
977: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;
978: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_ID;
979: l_trx_line_rec.program_applicaton_id
980: := fnd_global.RESP_APPL_ID;
981: l_trx_line_rec.program_update_date := SYSDATE;
982:

Line 980: := fnd_global.RESP_APPL_ID;

976: l_trx_line_rec.last_update_date := SYSDATE;
977: l_trx_line_rec.last_updated_by := fnd_global.USER_ID;
978: l_trx_line_rec.last_update_login:= fnd_global.LOGIN_ID;
979: l_trx_line_rec.program_applicaton_id
980: := fnd_global.RESP_APPL_ID;
981: l_trx_line_rec.program_update_date := SYSDATE;
982:
983: l_trx_line_tbl.EXTEND;
984: l_trx_line_tbl(l_trx_line_tbl.LAST):=l_trx_line_rec;

Line 1502: , export_request_id =fnd_global.CONC_REQUEST_ID

1498: --fill request_id etc. to P_INVOICE;
1499: UPDATE jmf_gta_trx_headers
1500: SET status='GENERATED'
1501: , gta_batch_number =p_batch_number
1502: , export_request_id =fnd_global.CONC_REQUEST_ID
1503: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1504: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1505: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1506: , PROGRAM_UPDATE_DATE =SYSDATE

Line 1503: , REQUEST_ID =fnd_global.CONC_REQUEST_ID

1499: UPDATE jmf_gta_trx_headers
1500: SET status='GENERATED'
1501: , gta_batch_number =p_batch_number
1502: , export_request_id =fnd_global.CONC_REQUEST_ID
1503: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1504: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1505: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1506: , PROGRAM_UPDATE_DATE =SYSDATE
1507: , LAST_UPDATE_DATE =SYSDATE

Line 1504: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID

1500: SET status='GENERATED'
1501: , gta_batch_number =p_batch_number
1502: , export_request_id =fnd_global.CONC_REQUEST_ID
1503: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1504: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1505: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1506: , PROGRAM_UPDATE_DATE =SYSDATE
1507: , LAST_UPDATE_DATE =SYSDATE
1508: , LAST_UPDATED_BY =fnd_global.USER_ID

Line 1505: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID

1501: , gta_batch_number =p_batch_number
1502: , export_request_id =fnd_global.CONC_REQUEST_ID
1503: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1504: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1505: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1506: , PROGRAM_UPDATE_DATE =SYSDATE
1507: , LAST_UPDATE_DATE =SYSDATE
1508: , LAST_UPDATED_BY =fnd_global.USER_ID
1509: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID

Line 1508: , LAST_UPDATED_BY =fnd_global.USER_ID

1504: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1505: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1506: , PROGRAM_UPDATE_DATE =SYSDATE
1507: , LAST_UPDATE_DATE =SYSDATE
1508: , LAST_UPDATED_BY =fnd_global.USER_ID
1509: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1510: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1511:
1512: ELSE -- x_success <> G_EXPORT_SUCC

Line 1509: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID

1505: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1506: , PROGRAM_UPDATE_DATE =SYSDATE
1507: , LAST_UPDATE_DATE =SYSDATE
1508: , LAST_UPDATED_BY =fnd_global.USER_ID
1509: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1510: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1511:
1512: ELSE -- x_success <> G_EXPORT_SUCC
1513: x_output(2):=g_comment_delimiter||l_header_output;

Line 1527: SET export_request_id =fnd_global.CONC_REQUEST_ID

1523: END LOOP;
1524: END IF ;
1525:
1526: UPDATE jmf_gta_trx_headers
1527: SET export_request_id =fnd_global.CONC_REQUEST_ID
1528: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1529: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1530: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1531: , PROGRAM_UPDATE_DATE =SYSDATE

Line 1528: , REQUEST_ID =fnd_global.CONC_REQUEST_ID

1524: END IF ;
1525:
1526: UPDATE jmf_gta_trx_headers
1527: SET export_request_id =fnd_global.CONC_REQUEST_ID
1528: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1529: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1530: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1531: , PROGRAM_UPDATE_DATE =SYSDATE
1532: , LAST_UPDATE_DATE =SYSDATE

Line 1529: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID

1525:
1526: UPDATE jmf_gta_trx_headers
1527: SET export_request_id =fnd_global.CONC_REQUEST_ID
1528: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1529: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1530: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1531: , PROGRAM_UPDATE_DATE =SYSDATE
1532: , LAST_UPDATE_DATE =SYSDATE
1533: , LAST_UPDATED_BY =fnd_global.USER_ID

Line 1530: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID

1526: UPDATE jmf_gta_trx_headers
1527: SET export_request_id =fnd_global.CONC_REQUEST_ID
1528: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1529: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1530: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1531: , PROGRAM_UPDATE_DATE =SYSDATE
1532: , LAST_UPDATE_DATE =SYSDATE
1533: , LAST_UPDATED_BY =fnd_global.USER_ID
1534: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID

Line 1533: , LAST_UPDATED_BY =fnd_global.USER_ID

1529: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1530: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1531: , PROGRAM_UPDATE_DATE =SYSDATE
1532: , LAST_UPDATE_DATE =SYSDATE
1533: , LAST_UPDATED_BY =fnd_global.USER_ID
1534: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1535: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1536:
1537: END IF;-- x_success = G_EXPORT_SUCC

Line 1534: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID

1530: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1531: , PROGRAM_UPDATE_DATE =SYSDATE
1532: , LAST_UPDATE_DATE =SYSDATE
1533: , LAST_UPDATED_BY =fnd_global.USER_ID
1534: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1535: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1536:
1537: END IF;-- x_success = G_EXPORT_SUCC
1538:

Line 1540: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID

1536:
1537: END IF;-- x_success = G_EXPORT_SUCC
1538:
1539: UPDATE jmf_gta_trx_lines
1540: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID
1541: , program_application_id =fnd_global.RESP_APPL_ID
1542: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1543: , PROGRAM_UPDATE_DATE =SYSDATE
1544: , LAST_UPDATE_DATE =SYSDATE

Line 1541: , program_application_id =fnd_global.RESP_APPL_ID

1537: END IF;-- x_success = G_EXPORT_SUCC
1538:
1539: UPDATE jmf_gta_trx_lines
1540: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID
1541: , program_application_id =fnd_global.RESP_APPL_ID
1542: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1543: , PROGRAM_UPDATE_DATE =SYSDATE
1544: , LAST_UPDATE_DATE =SYSDATE
1545: , LAST_UPDATED_BY =fnd_global.USER_ID

Line 1542: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID

1538:
1539: UPDATE jmf_gta_trx_lines
1540: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID
1541: , program_application_id =fnd_global.RESP_APPL_ID
1542: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1543: , PROGRAM_UPDATE_DATE =SYSDATE
1544: , LAST_UPDATE_DATE =SYSDATE
1545: , LAST_UPDATED_BY =fnd_global.USER_ID
1546: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID

Line 1545: , LAST_UPDATED_BY =fnd_global.USER_ID

1541: , program_application_id =fnd_global.RESP_APPL_ID
1542: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1543: , PROGRAM_UPDATE_DATE =SYSDATE
1544: , LAST_UPDATE_DATE =SYSDATE
1545: , LAST_UPDATED_BY =fnd_global.USER_ID
1546: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1547: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id
1548: AND ENABLED_FLAG='Y';
1549:

Line 1546: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID

1542: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1543: , PROGRAM_UPDATE_DATE =SYSDATE
1544: , LAST_UPDATE_DATE =SYSDATE
1545: , LAST_UPDATED_BY =fnd_global.USER_ID
1546: , LAST_UPDATE_LOGIN =fnd_global.LOGIN_ID
1547: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id
1548: AND ENABLED_FLAG='Y';
1549:
1550: --log for debug