DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on FND_GLOBAL

Line 902: last_updated_by = FND_GLOBAL.USER_ID,

898: ELSE 'Y'
899: END
900: ), --
901: last_update_date = SYSDATE,
902: last_updated_by = FND_GLOBAL.USER_ID,
903: last_update_login = FND_GLOBAL.LOGIN_ID
904: where auction_header_id = x_negotiation_id;
905:
906: else

Line 903: last_update_login = FND_GLOBAL.LOGIN_ID

899: END
900: ), --
901: last_update_date = SYSDATE,
902: last_updated_by = FND_GLOBAL.USER_ID,
903: last_update_login = FND_GLOBAL.LOGIN_ID
904: where auction_header_id = x_negotiation_id;
905:
906: else
907: -- : added update of at_sourcing_flag and of

Line 935: last_updated_by = FND_GLOBAL.USER_ID,

931: ELSE 'Y'
932: END
933: ), --
934: last_update_date = SYSDATE,
935: last_updated_by = FND_GLOBAL.USER_ID,
936: last_update_login = FND_GLOBAL.LOGIN_ID
937: where auction_header_id = x_negotiation_id
938: and auction_line_number = x_negotiation_line_num;
939: end if;

Line 936: last_update_login = FND_GLOBAL.LOGIN_ID

932: END
933: ), --
934: last_update_date = SYSDATE,
935: last_updated_by = FND_GLOBAL.USER_ID,
936: last_update_login = FND_GLOBAL.LOGIN_ID
937: where auction_header_id = x_negotiation_id
938: and auction_line_number = x_negotiation_line_num;
939: end if;
940:

Line 1080: last_updated_by = FND_GLOBAL.USER_ID,

1076: update po_requisition_lines_all prla --Bug 4001965: use _all
1077: set reqs_in_pool_flag = x_new_pool_value,
1078: at_sourcing_flag = x_sourcing_flag_value, --
1079: last_update_date = SYSDATE,
1080: last_updated_by = FND_GLOBAL.USER_ID,
1081: last_update_login = FND_GLOBAL.LOGIN_ID
1082: where auction_header_id = x_negotiation_id
1083: -- We only want to set the reqs_in_pool_flag to 'Y'
1084: --if all of the following conditions are met.

Line 1081: last_update_login = FND_GLOBAL.LOGIN_ID

1077: set reqs_in_pool_flag = x_new_pool_value,
1078: at_sourcing_flag = x_sourcing_flag_value, --
1079: last_update_date = SYSDATE,
1080: last_updated_by = FND_GLOBAL.USER_ID,
1081: last_update_login = FND_GLOBAL.LOGIN_ID
1082: where auction_header_id = x_negotiation_id
1083: -- We only want to set the reqs_in_pool_flag to 'Y'
1084: --if all of the following conditions are met.
1085: and nvl(modified_by_agent_flag,'N') <> 'Y' --

Line 1105: last_updated_by = FND_GLOBAL.USER_ID,

1101: update po_requisition_lines_all prla --Bug 4001965: use _all
1102: set reqs_in_pool_flag = x_new_pool_value,
1103: at_sourcing_flag = x_sourcing_flag_value, --
1104: last_update_date = SYSDATE,
1105: last_updated_by = FND_GLOBAL.USER_ID,
1106: last_update_login = FND_GLOBAL.LOGIN_ID
1107: where auction_header_id = x_negotiation_id
1108: and auction_line_number = x_negotiation_line_num
1109: -- We only want to set the reqs_in_pool_flag to 'Y'

Line 1106: last_update_login = FND_GLOBAL.LOGIN_ID

1102: set reqs_in_pool_flag = x_new_pool_value,
1103: at_sourcing_flag = x_sourcing_flag_value, --
1104: last_update_date = SYSDATE,
1105: last_updated_by = FND_GLOBAL.USER_ID,
1106: last_update_login = FND_GLOBAL.LOGIN_ID
1107: where auction_header_id = x_negotiation_id
1108: and auction_line_number = x_negotiation_line_num
1109: -- We only want to set the reqs_in_pool_flag to 'Y'
1110: --if all of the following conditions are met.

Line 1288: l_user_id := FND_GLOBAL.USER_ID;

1284:
1285: l_progress := '001';
1286:
1287: --Bug 2694722 : Getting user id
1288: l_user_id := FND_GLOBAL.USER_ID;
1289:
1290: --Populate PON_AUC_HEADERS_INTERFACE table
1291: insert into pon_auc_headers_interface(
1292: interface_auction_header_id,