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.

[Home] [Help]

APPS.PO_LINES_SV4_832_UPDATE dependencies on FND_GLOBAL

Line 448: last_updated_by = fnd_global.user_id,

444:
445: UPDATE mtl_system_items
446: SET description = x_item_description,
447: last_update_date = sysdate,
448: last_updated_by = fnd_global.user_id,
449: last_update_login = fnd_global.login_id,
450: request_id = fnd_global.conc_request_id,
451: program_application_id = fnd_global.prog_appl_id,
452: program_id = fnd_global.conc_program_id,

Line 449: last_update_login = fnd_global.login_id,

445: UPDATE mtl_system_items
446: SET description = x_item_description,
447: last_update_date = sysdate,
448: last_updated_by = fnd_global.user_id,
449: last_update_login = fnd_global.login_id,
450: request_id = fnd_global.conc_request_id,
451: program_application_id = fnd_global.prog_appl_id,
452: program_id = fnd_global.conc_program_id,
453: program_update_date = sysdate

Line 450: request_id = fnd_global.conc_request_id,

446: SET description = x_item_description,
447: last_update_date = sysdate,
448: last_updated_by = fnd_global.user_id,
449: last_update_login = fnd_global.login_id,
450: request_id = fnd_global.conc_request_id,
451: program_application_id = fnd_global.prog_appl_id,
452: program_id = fnd_global.conc_program_id,
453: program_update_date = sysdate
454: WHERE inventory_item_id = X_item_id

Line 451: program_application_id = fnd_global.prog_appl_id,

447: last_update_date = sysdate,
448: last_updated_by = fnd_global.user_id,
449: last_update_login = fnd_global.login_id,
450: request_id = fnd_global.conc_request_id,
451: program_application_id = fnd_global.prog_appl_id,
452: program_id = fnd_global.conc_program_id,
453: program_update_date = sysdate
454: WHERE inventory_item_id = X_item_id
455: AND organization_id = x_def_master_org_id;

Line 452: program_id = fnd_global.conc_program_id,

448: last_updated_by = fnd_global.user_id,
449: last_update_login = fnd_global.login_id,
450: request_id = fnd_global.conc_request_id,
451: program_application_id = fnd_global.prog_appl_id,
452: program_id = fnd_global.conc_program_id,
453: program_update_date = sysdate
454: WHERE inventory_item_id = X_item_id
455: AND organization_id = x_def_master_org_id;
456:

Line 478: last_updated_by = fnd_global.user_id,

474:
475: UPDATE po_lines
476: SET item_description = x_item_description,
477: last_update_date = sysdate,
478: last_updated_by = fnd_global.user_id,
479: last_update_login = fnd_global.login_id,
480: request_id = fnd_global.conc_request_id,
481: program_application_id = fnd_global.prog_appl_id,
482: program_id = fnd_global.conc_program_id,

Line 479: last_update_login = fnd_global.login_id,

475: UPDATE po_lines
476: SET item_description = x_item_description,
477: last_update_date = sysdate,
478: last_updated_by = fnd_global.user_id,
479: last_update_login = fnd_global.login_id,
480: request_id = fnd_global.conc_request_id,
481: program_application_id = fnd_global.prog_appl_id,
482: program_id = fnd_global.conc_program_id,
483: program_update_date = sysdate

Line 480: request_id = fnd_global.conc_request_id,

476: SET item_description = x_item_description,
477: last_update_date = sysdate,
478: last_updated_by = fnd_global.user_id,
479: last_update_login = fnd_global.login_id,
480: request_id = fnd_global.conc_request_id,
481: program_application_id = fnd_global.prog_appl_id,
482: program_id = fnd_global.conc_program_id,
483: program_update_date = sysdate
484: WHERE po_line_id = x_po_line_id

Line 481: program_application_id = fnd_global.prog_appl_id,

477: last_update_date = sysdate,
478: last_updated_by = fnd_global.user_id,
479: last_update_login = fnd_global.login_id,
480: request_id = fnd_global.conc_request_id,
481: program_application_id = fnd_global.prog_appl_id,
482: program_id = fnd_global.conc_program_id,
483: program_update_date = sysdate
484: WHERE po_line_id = x_po_line_id
485: AND po_header_id = x_current_po_header_id;

Line 482: program_id = fnd_global.conc_program_id,

478: last_updated_by = fnd_global.user_id,
479: last_update_login = fnd_global.login_id,
480: request_id = fnd_global.conc_request_id,
481: program_application_id = fnd_global.prog_appl_id,
482: program_id = fnd_global.conc_program_id,
483: program_update_date = sysdate
484: WHERE po_line_id = x_po_line_id
485: AND po_header_id = x_current_po_header_id;
486:

Line 578: last_updated_by = fnd_global.user_id,

574: SET unit_price = X_unit_price,
575: base_unit_price = NVL(X_base_unit_price, X_unit_price), --
576: retroactive_date = l_retroactive_date, -- 2722795
577: last_update_date = sysdate,
578: last_updated_by = fnd_global.user_id,
579: last_update_login = fnd_global.login_id,
580: request_id = fnd_global.conc_request_id,
581: program_application_id = fnd_global.prog_appl_id,
582: program_id = fnd_global.conc_program_id,

Line 579: last_update_login = fnd_global.login_id,

575: base_unit_price = NVL(X_base_unit_price, X_unit_price), --
576: retroactive_date = l_retroactive_date, -- 2722795
577: last_update_date = sysdate,
578: last_updated_by = fnd_global.user_id,
579: last_update_login = fnd_global.login_id,
580: request_id = fnd_global.conc_request_id,
581: program_application_id = fnd_global.prog_appl_id,
582: program_id = fnd_global.conc_program_id,
583: program_update_date = sysdate

Line 580: request_id = fnd_global.conc_request_id,

576: retroactive_date = l_retroactive_date, -- 2722795
577: last_update_date = sysdate,
578: last_updated_by = fnd_global.user_id,
579: last_update_login = fnd_global.login_id,
580: request_id = fnd_global.conc_request_id,
581: program_application_id = fnd_global.prog_appl_id,
582: program_id = fnd_global.conc_program_id,
583: program_update_date = sysdate
584: WHERE po_line_id = x_po_line_id

Line 581: program_application_id = fnd_global.prog_appl_id,

577: last_update_date = sysdate,
578: last_updated_by = fnd_global.user_id,
579: last_update_login = fnd_global.login_id,
580: request_id = fnd_global.conc_request_id,
581: program_application_id = fnd_global.prog_appl_id,
582: program_id = fnd_global.conc_program_id,
583: program_update_date = sysdate
584: WHERE po_line_id = x_po_line_id
585: AND po_header_id = x_current_po_header_id;

Line 582: program_id = fnd_global.conc_program_id,

578: last_updated_by = fnd_global.user_id,
579: last_update_login = fnd_global.login_id,
580: request_id = fnd_global.conc_request_id,
581: program_application_id = fnd_global.prog_appl_id,
582: program_id = fnd_global.conc_program_id,
583: program_update_date = sysdate
584: WHERE po_line_id = x_po_line_id
585: AND po_header_id = x_current_po_header_id;
586:

Line 626: last_updated_by = fnd_global.user_id,

622: IF(l_update_exp_date) THEN
623: UPDATE po_lines
624: SET expiration_date = trunc(x_expiration_date),
625: last_update_date = trunc(sysdate),
626: last_updated_by = fnd_global.user_id,
627: last_update_login = fnd_global.login_id,
628: request_id = fnd_global.conc_request_id,
629: program_application_id = fnd_global.prog_appl_id,
630: program_id = fnd_global.conc_program_id,

Line 627: last_update_login = fnd_global.login_id,

623: UPDATE po_lines
624: SET expiration_date = trunc(x_expiration_date),
625: last_update_date = trunc(sysdate),
626: last_updated_by = fnd_global.user_id,
627: last_update_login = fnd_global.login_id,
628: request_id = fnd_global.conc_request_id,
629: program_application_id = fnd_global.prog_appl_id,
630: program_id = fnd_global.conc_program_id,
631: program_update_date = trunc(sysdate)

Line 628: request_id = fnd_global.conc_request_id,

624: SET expiration_date = trunc(x_expiration_date),
625: last_update_date = trunc(sysdate),
626: last_updated_by = fnd_global.user_id,
627: last_update_login = fnd_global.login_id,
628: request_id = fnd_global.conc_request_id,
629: program_application_id = fnd_global.prog_appl_id,
630: program_id = fnd_global.conc_program_id,
631: program_update_date = trunc(sysdate)
632: WHERE po_line_id = x_po_line_id

Line 629: program_application_id = fnd_global.prog_appl_id,

625: last_update_date = trunc(sysdate),
626: last_updated_by = fnd_global.user_id,
627: last_update_login = fnd_global.login_id,
628: request_id = fnd_global.conc_request_id,
629: program_application_id = fnd_global.prog_appl_id,
630: program_id = fnd_global.conc_program_id,
631: program_update_date = trunc(sysdate)
632: WHERE po_line_id = x_po_line_id
633: AND po_header_id = x_current_po_header_id;

Line 630: program_id = fnd_global.conc_program_id,

626: last_updated_by = fnd_global.user_id,
627: last_update_login = fnd_global.login_id,
628: request_id = fnd_global.conc_request_id,
629: program_application_id = fnd_global.prog_appl_id,
630: program_id = fnd_global.conc_program_id,
631: program_update_date = trunc(sysdate)
632: WHERE po_line_id = x_po_line_id
633: AND po_header_id = x_current_po_header_id;
634: END IF;

Line 712: last_updated_by = fnd_global.user_id,

708: unit_price = l_conv_price,
709: base_unit_price = NVL(X_base_unit_price, l_conv_price),
710: retroactive_date = l_retroactive_date,
711: last_update_date = sysdate,
712: last_updated_by = fnd_global.user_id,
713: last_update_login = fnd_global.login_id,
714: request_id = fnd_global.conc_request_id,
715: program_application_id = fnd_global.prog_appl_id,
716: program_id = fnd_global.conc_program_id,

Line 713: last_update_login = fnd_global.login_id,

709: base_unit_price = NVL(X_base_unit_price, l_conv_price),
710: retroactive_date = l_retroactive_date,
711: last_update_date = sysdate,
712: last_updated_by = fnd_global.user_id,
713: last_update_login = fnd_global.login_id,
714: request_id = fnd_global.conc_request_id,
715: program_application_id = fnd_global.prog_appl_id,
716: program_id = fnd_global.conc_program_id,
717: program_update_date = sysdate

Line 714: request_id = fnd_global.conc_request_id,

710: retroactive_date = l_retroactive_date,
711: last_update_date = sysdate,
712: last_updated_by = fnd_global.user_id,
713: last_update_login = fnd_global.login_id,
714: request_id = fnd_global.conc_request_id,
715: program_application_id = fnd_global.prog_appl_id,
716: program_id = fnd_global.conc_program_id,
717: program_update_date = sysdate
718: WHERE po_line_id = x_po_line_id

Line 715: program_application_id = fnd_global.prog_appl_id,

711: last_update_date = sysdate,
712: last_updated_by = fnd_global.user_id,
713: last_update_login = fnd_global.login_id,
714: request_id = fnd_global.conc_request_id,
715: program_application_id = fnd_global.prog_appl_id,
716: program_id = fnd_global.conc_program_id,
717: program_update_date = sysdate
718: WHERE po_line_id = x_po_line_id
719: AND po_header_id = x_current_po_header_id;

Line 716: program_id = fnd_global.conc_program_id,

712: last_updated_by = fnd_global.user_id,
713: last_update_login = fnd_global.login_id,
714: request_id = fnd_global.conc_request_id,
715: program_application_id = fnd_global.prog_appl_id,
716: program_id = fnd_global.conc_program_id,
717: program_update_date = sysdate
718: WHERE po_line_id = x_po_line_id
719: AND po_header_id = x_current_po_header_id;
720:

Line 786: last_updated_by = fnd_global.user_id,

782:
783: UPDATE po_lines
784: SET ATTRIBUTE14 = X_line_attribute14,
785: last_update_date = sysdate,
786: last_updated_by = fnd_global.user_id,
787: last_update_login = fnd_global.login_id,
788: request_id = fnd_global.conc_request_id,
789: program_application_id = fnd_global.prog_appl_id,
790: program_id = fnd_global.conc_program_id,

Line 787: last_update_login = fnd_global.login_id,

783: UPDATE po_lines
784: SET ATTRIBUTE14 = X_line_attribute14,
785: last_update_date = sysdate,
786: last_updated_by = fnd_global.user_id,
787: last_update_login = fnd_global.login_id,
788: request_id = fnd_global.conc_request_id,
789: program_application_id = fnd_global.prog_appl_id,
790: program_id = fnd_global.conc_program_id,
791: program_update_date = sysdate

Line 788: request_id = fnd_global.conc_request_id,

784: SET ATTRIBUTE14 = X_line_attribute14,
785: last_update_date = sysdate,
786: last_updated_by = fnd_global.user_id,
787: last_update_login = fnd_global.login_id,
788: request_id = fnd_global.conc_request_id,
789: program_application_id = fnd_global.prog_appl_id,
790: program_id = fnd_global.conc_program_id,
791: program_update_date = sysdate
792: WHERE po_line_id = x_po_line_id

Line 789: program_application_id = fnd_global.prog_appl_id,

785: last_update_date = sysdate,
786: last_updated_by = fnd_global.user_id,
787: last_update_login = fnd_global.login_id,
788: request_id = fnd_global.conc_request_id,
789: program_application_id = fnd_global.prog_appl_id,
790: program_id = fnd_global.conc_program_id,
791: program_update_date = sysdate
792: WHERE po_line_id = x_po_line_id
793: AND po_header_id = x_current_po_header_id;

Line 790: program_id = fnd_global.conc_program_id,

786: last_updated_by = fnd_global.user_id,
787: last_update_login = fnd_global.login_id,
788: request_id = fnd_global.conc_request_id,
789: program_application_id = fnd_global.prog_appl_id,
790: program_id = fnd_global.conc_program_id,
791: program_update_date = sysdate
792: WHERE po_line_id = x_po_line_id
793: AND po_header_id = x_current_po_header_id;
794:

Line 808: last_updated_by = FND_GLOBAL.user_id,

804: IF (NVL(p_amount, 0) <> 0) THEN
805: UPDATE PO_LINES
806: SET amount = p_amount,
807: last_update_date = sysdate,
808: last_updated_by = FND_GLOBAL.user_id,
809: last_update_login = FND_GLOBAL.login_id,
810: request_id = FND_GLOBAL.conc_request_id,
811: program_application_id = FND_GLOBAL.prog_appl_id,
812: program_id = FND_GLOBAL.conc_program_id,

Line 809: last_update_login = FND_GLOBAL.login_id,

805: UPDATE PO_LINES
806: SET amount = p_amount,
807: last_update_date = sysdate,
808: last_updated_by = FND_GLOBAL.user_id,
809: last_update_login = FND_GLOBAL.login_id,
810: request_id = FND_GLOBAL.conc_request_id,
811: program_application_id = FND_GLOBAL.prog_appl_id,
812: program_id = FND_GLOBAL.conc_program_id,
813: program_update_date = sysdate

Line 810: request_id = FND_GLOBAL.conc_request_id,

806: SET amount = p_amount,
807: last_update_date = sysdate,
808: last_updated_by = FND_GLOBAL.user_id,
809: last_update_login = FND_GLOBAL.login_id,
810: request_id = FND_GLOBAL.conc_request_id,
811: program_application_id = FND_GLOBAL.prog_appl_id,
812: program_id = FND_GLOBAL.conc_program_id,
813: program_update_date = sysdate
814: WHERE po_line_id = x_po_line_id

Line 811: program_application_id = FND_GLOBAL.prog_appl_id,

807: last_update_date = sysdate,
808: last_updated_by = FND_GLOBAL.user_id,
809: last_update_login = FND_GLOBAL.login_id,
810: request_id = FND_GLOBAL.conc_request_id,
811: program_application_id = FND_GLOBAL.prog_appl_id,
812: program_id = FND_GLOBAL.conc_program_id,
813: program_update_date = sysdate
814: WHERE po_line_id = x_po_line_id
815: AND po_header_id = x_current_po_header_id;

Line 812: program_id = FND_GLOBAL.conc_program_id,

808: last_updated_by = FND_GLOBAL.user_id,
809: last_update_login = FND_GLOBAL.login_id,
810: request_id = FND_GLOBAL.conc_request_id,
811: program_application_id = FND_GLOBAL.prog_appl_id,
812: program_id = FND_GLOBAL.conc_program_id,
813: program_update_date = sysdate
814: WHERE po_line_id = x_po_line_id
815: AND po_header_id = x_current_po_header_id;
816: END IF;

Line 1303: last_updated_by = fnd_global.user_id,

1299: update po_lines
1300: set deleted_item_flag = 'Y'
1301: -- set expiration_date = (select sysdate from sys.dual) or X_expiration_date
1302: last_update_date = sysdate,
1303: last_updated_by = fnd_global.user_id,
1304: last_update_login = fnd_global.login_id,
1305: request_id = fnd_global.conc_request_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,

Line 1304: last_update_login = fnd_global.login_id,

1300: set deleted_item_flag = 'Y'
1301: -- set expiration_date = (select sysdate from sys.dual) or X_expiration_date
1302: last_update_date = sysdate,
1303: last_updated_by = fnd_global.user_id,
1304: last_update_login = fnd_global.login_id,
1305: request_id = fnd_global.conc_request_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,
1308: program_update_date = sysdate

Line 1305: request_id = fnd_global.conc_request_id,

1301: -- set expiration_date = (select sysdate from sys.dual) or X_expiration_date
1302: last_update_date = sysdate,
1303: last_updated_by = fnd_global.user_id,
1304: last_update_login = fnd_global.login_id,
1305: request_id = fnd_global.conc_request_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,
1308: program_update_date = sysdate
1309: where po_header_id = X_po_header_id

Line 1306: program_application_id = fnd_global.prog_appl_id,

1302: last_update_date = sysdate,
1303: last_updated_by = fnd_global.user_id,
1304: last_update_login = fnd_global.login_id,
1305: request_id = fnd_global.conc_request_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,
1308: program_update_date = sysdate
1309: where po_header_id = X_po_header_id
1310: and po_line_id = X_po_line_id;

Line 1307: program_id = fnd_global.conc_program_id,

1303: last_updated_by = fnd_global.user_id,
1304: last_update_login = fnd_global.login_id,
1305: request_id = fnd_global.conc_request_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,
1308: program_update_date = sysdate
1309: where po_header_id = X_po_header_id
1310: and po_line_id = X_po_line_id;
1311: */