DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on FND_GLOBAL

Line 655: last_updated_by = FND_GLOBAL.user_id

651: SET
652: scoring_type = 'NONE',
653: weight = 0,
654: last_update_date = sysdate,
655: last_updated_by = FND_GLOBAL.user_id
656: WHERE
657: auction_header_id = p_auction_header_id AND
658: line_number >= l_batch_start AND
659: line_number <= l_batch_end;

Line 966: PBP.sequence,null,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id

962:
963: insert into PON_LARGE_NEG_PF_VALUES (auction_header_id,price_element_type_id,pricing_basis,
964: supplier_seq_number,value,creation_date,created_by,last_update_date,last_updated_by,last_update_login)
965: select distinct PPE.auction_header_id,PPE.price_element_type_id,PPE.pricing_basis,
966: PBP.sequence,null,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id
967: from
968: PON_PRICE_ELEMENTS PPE, PON_BIDDING_PARTIES PBP
969: where
970: PPE.auction_header_id = p_auction_header_id and

Line 1121: p_supplier_seq_num,null,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id

1117:
1118: insert into PON_LARGE_NEG_PF_VALUES (auction_header_id,price_element_type_id,pricing_basis,
1119: supplier_seq_number,value,creation_date,created_by,last_update_date,last_updated_by,last_update_login)
1120: select auction_header_id,price_element_type_id,pricing_basis,
1121: p_supplier_seq_num,null,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id
1122: from
1123: PON_LARGE_NEG_PF_VALUES
1124: where
1125: auction_header_id = p_auction_header_id and

Line 1139: p_supplier_seq_num,null,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id

1135:
1136: insert into PON_LARGE_NEG_PF_VALUES (auction_header_id,price_element_type_id,pricing_basis,
1137: supplier_seq_number,value,creation_date,created_by,last_update_date,last_updated_by,last_update_login)
1138: select distinct auction_header_id,price_element_type_id,pricing_basis,
1139: p_supplier_seq_num,null,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id
1140: from
1141: PON_PRICE_ELEMENTS
1142: where
1143: auction_header_id = p_auction_header_id and

Line 2886: l_login_id := FND_GLOBAL.LOGIN_ID;

2882: module => g_module_prefix || 'RENUMBER_LINES',
2883: message => 'Number of lines collected = ' || l_line_number.COUNT);
2884: END IF;
2885:
2886: l_login_id := FND_GLOBAL.LOGIN_ID;
2887: l_user_id := FND_GLOBAL.USER_ID;
2888:
2889: --CHECK IF ANY LINES EXIST AFTER THE MIN DISP_LINE_NUMBER
2890: --IF NOT THEN NO NEED TO RENUMBER ANY PARENT TYPE LINES

Line 2887: l_user_id := FND_GLOBAL.USER_ID;

2883: message => 'Number of lines collected = ' || l_line_number.COUNT);
2884: END IF;
2885:
2886: l_login_id := FND_GLOBAL.LOGIN_ID;
2887: l_user_id := FND_GLOBAL.USER_ID;
2888:
2889: --CHECK IF ANY LINES EXIST AFTER THE MIN DISP_LINE_NUMBER
2890: --IF NOT THEN NO NEED TO RENUMBER ANY PARENT TYPE LINES
2891: IF (l_line_number.COUNT > 0) THEN --{