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.PO_R12_CAT_UPG_DEF_PVT dependencies on FND_GLOBAL

Line 200: p_headers_rec.last_updated_by(i) := FND_GLOBAL.user_id; -- who column

196: --p_headers_rec.agent_id(i) -- TODO: Open issue with PM
197: p_headers_rec.document_type_code(i) := 'PO'; -- Only present in interface table, not in txn table
198: p_headers_rec.document_subtype(i) := 'BLANKET'; -- TYPE_LOOKUP_CODE in txn tables
199: p_headers_rec.last_update_date(i) := sysdate; -- who column
200: p_headers_rec.last_updated_by(i) := FND_GLOBAL.user_id; -- who column
201:
202: l_progress := '072';
203: --p_headers_rec.summary_flag(i) := 'N'; -- Key flexfield related, for future use. Not present in interface tables
204: --p_headers_rec.enabled_flag(i) := 'Y'; -- Key flexfield related, for future use. Not present in interface tables

Line 212: p_headers_rec.last_update_login(i) := FND_GLOBAL.login_id; -- who column

208: --p_headers_rec.segment4(i) := NULL;
209: --p_headers_rec.segment5(i) := NULL;
210: --p_headers_rec.start_date_active(i) := NULL; -- Key Flexfield start date. Not present in interface tables
211: --p_headers_rec.end_date_active(i) := NULL; -- Key Flexfield start date. Not present in interface tables
212: p_headers_rec.last_update_login(i) := FND_GLOBAL.login_id; -- who column
213: p_headers_rec.creation_date(i) := sysdate; -- who column
214: p_headers_rec.created_by(i) := PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER; -- -12
215:
216: l_progress := '073';

Line 293: p_headers_rec.request_id(i) := FND_GLOBAL.conc_request_id; -- NUMBER iPs conc program request id

289: p_headers_rec.ussgl_transaction_code(i) := NULL;
290: l_progress := '076';
291:
292: --p_headers_rec.government_context(i) := NULL; Not present in interface tables
293: p_headers_rec.request_id(i) := FND_GLOBAL.conc_request_id; -- NUMBER iPs conc program request id
294: p_headers_rec.program_application_id(i) := FND_GLOBAL.prog_appl_id; -- NUMBER
295: p_headers_rec.program_id(i) := FND_GLOBAL.conc_program_id; -- NUMBER
296: p_headers_rec.program_update_date(i) := sysdate; -- DATE
297:

Line 294: p_headers_rec.program_application_id(i) := FND_GLOBAL.prog_appl_id; -- NUMBER

290: l_progress := '076';
291:
292: --p_headers_rec.government_context(i) := NULL; Not present in interface tables
293: p_headers_rec.request_id(i) := FND_GLOBAL.conc_request_id; -- NUMBER iPs conc program request id
294: p_headers_rec.program_application_id(i) := FND_GLOBAL.prog_appl_id; -- NUMBER
295: p_headers_rec.program_id(i) := FND_GLOBAL.conc_program_id; -- NUMBER
296: p_headers_rec.program_update_date(i) := sysdate; -- DATE
297:
298: l_progress := '077';

Line 295: p_headers_rec.program_id(i) := FND_GLOBAL.conc_program_id; -- NUMBER

291:
292: --p_headers_rec.government_context(i) := NULL; Not present in interface tables
293: p_headers_rec.request_id(i) := FND_GLOBAL.conc_request_id; -- NUMBER iPs conc program request id
294: p_headers_rec.program_application_id(i) := FND_GLOBAL.prog_appl_id; -- NUMBER
295: p_headers_rec.program_id(i) := FND_GLOBAL.conc_program_id; -- NUMBER
296: p_headers_rec.program_update_date(i) := sysdate; -- DATE
297:
298: l_progress := '077';
299: --p_headers_rec.org_id(i) -- Copy value from interface table.

Line 1580: p_lines_rec.last_updated_by(i) := FND_GLOBAL.user_id; -- NOT NULL NUMBER FND_GLOBAL.user_id

1576: --------------------------------------------------------------
1577: --p_lines_rec.po_line_id(i) := NULL; -- NOT NULL NUMBER From sequence PO_LINES_S
1578: p_lines_rec.last_update_date(i) := sysdate; -- NOT NULL DATE Sysdate
1579: l_progress := '131';
1580: p_lines_rec.last_updated_by(i) := FND_GLOBAL.user_id; -- NOT NULL NUMBER FND_GLOBAL.user_id
1581: --p_lines_rec.po_header_id(i) := NULL; -- NOT NULL NUMBER From the PO header created in the same flow
1582: --p_lines_rec.line_type_id(i) := NULL; -- NOT NULL NUMBER Default as in PDOI(Open issue) In PDOI it is a must column/parameter like buyer
1583: --p_lines_rec.line_num(i) := NULL; -- NOT NULL NUMBER Default as in PDOI
1584: p_lines_rec.last_update_login(i) := FND_GLOBAL.login_id; -- NUMBER FND_GLOBAL.login_id

Line 1584: p_lines_rec.last_update_login(i) := FND_GLOBAL.login_id; -- NUMBER FND_GLOBAL.login_id

1580: p_lines_rec.last_updated_by(i) := FND_GLOBAL.user_id; -- NOT NULL NUMBER FND_GLOBAL.user_id
1581: --p_lines_rec.po_header_id(i) := NULL; -- NOT NULL NUMBER From the PO header created in the same flow
1582: --p_lines_rec.line_type_id(i) := NULL; -- NOT NULL NUMBER Default as in PDOI(Open issue) In PDOI it is a must column/parameter like buyer
1583: --p_lines_rec.line_num(i) := NULL; -- NOT NULL NUMBER Default as in PDOI
1584: p_lines_rec.last_update_login(i) := FND_GLOBAL.login_id; -- NUMBER FND_GLOBAL.login_id
1585: p_lines_rec.creation_date(i) := sysdate; -- DATE sysdate
1586: p_lines_rec.created_by(i) := PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER; -- NUMBER -12 (suggested by iP)
1587: --p_lines_rec.item_id(i) := NULL; -- NUMBER Copy value from interface table
1588: --p_lines_rec.item_revision(i) := NULL; -- VARCHAR2(3) Copy value from interface table

Line 1650: p_lines_rec.request_id(i) := FND_GLOBAL.conc_request_id; -- NUMBER iPs conc program request id

1646: p_lines_rec.price_break_lookup_code(i) := NULL; -- VARCHAR2(25) NULL (For GA's)
1647: p_lines_rec.ussgl_transaction_code(i) := NULL; -- VARCHAR2(30) NULL
1648: --p_lines_rec.government_context(i) := NULL; -- VARCHAR2(30) NULL -- TODO: ONLY PRESENT IN TXN TABLES
1649: l_progress := '135';
1650: p_lines_rec.request_id(i) := FND_GLOBAL.conc_request_id; -- NUMBER iPs conc program request id
1651: p_lines_rec.program_application_id(i) := FND_GLOBAL.prog_appl_id; -- NUMBER
1652: p_lines_rec.program_id(i) := FND_GLOBAL.conc_program_id; -- NUMBER
1653: p_lines_rec.program_update_date(i) := sysdate; -- DATE
1654: p_lines_rec.closed_date(i) := NULL; -- DATE NULL

Line 1651: p_lines_rec.program_application_id(i) := FND_GLOBAL.prog_appl_id; -- NUMBER

1647: p_lines_rec.ussgl_transaction_code(i) := NULL; -- VARCHAR2(30) NULL
1648: --p_lines_rec.government_context(i) := NULL; -- VARCHAR2(30) NULL -- TODO: ONLY PRESENT IN TXN TABLES
1649: l_progress := '135';
1650: p_lines_rec.request_id(i) := FND_GLOBAL.conc_request_id; -- NUMBER iPs conc program request id
1651: p_lines_rec.program_application_id(i) := FND_GLOBAL.prog_appl_id; -- NUMBER
1652: p_lines_rec.program_id(i) := FND_GLOBAL.conc_program_id; -- NUMBER
1653: p_lines_rec.program_update_date(i) := sysdate; -- DATE
1654: p_lines_rec.closed_date(i) := NULL; -- DATE NULL
1655: p_lines_rec.closed_reason(i) := NULL; -- VARCHAR2(240) NULL

Line 1652: p_lines_rec.program_id(i) := FND_GLOBAL.conc_program_id; -- NUMBER

1648: --p_lines_rec.government_context(i) := NULL; -- VARCHAR2(30) NULL -- TODO: ONLY PRESENT IN TXN TABLES
1649: l_progress := '135';
1650: p_lines_rec.request_id(i) := FND_GLOBAL.conc_request_id; -- NUMBER iPs conc program request id
1651: p_lines_rec.program_application_id(i) := FND_GLOBAL.prog_appl_id; -- NUMBER
1652: p_lines_rec.program_id(i) := FND_GLOBAL.conc_program_id; -- NUMBER
1653: p_lines_rec.program_update_date(i) := sysdate; -- DATE
1654: p_lines_rec.closed_date(i) := NULL; -- DATE NULL
1655: p_lines_rec.closed_reason(i) := NULL; -- VARCHAR2(240) NULL
1656: p_lines_rec.closed_by(i) := NULL; -- NUMBER(9) NULL