DBA Data[Home] [Help]

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on FND_GLOBAL

Line 144: fnd_global.APPS_INITIALIZE (p_user_id, x_responsibility_id, x_application_id);

140: FND_PROFILE.GET('RESP_ID', x_responsibility_id);
141:
142: FND_PROFILE.GET('RESP_APPL_ID', x_application_id);
143:
144: fnd_global.APPS_INITIALIZE (p_user_id, x_responsibility_id, x_application_id);
145: --bug 5245568; need to call init to intialize MOAC
146: mo_global.init('PON');
147:
148: if(l_debug_enabled = 'Y') then

Line 1159: l_user_id := fnd_global.user_id;

1155: x_progress := '33: Right before Bulk Insert';
1156: log_message(x_progress);
1157:
1158:
1159: l_user_id := fnd_global.user_id;
1160: l_login_id := fnd_global.login_id;
1161:
1162: -- doing bulk insert
1163: FORALL l_count IN 1..l_bid_number_insertcol.COUNT

Line 1160: l_login_id := fnd_global.login_id;

1156: log_message(x_progress);
1157:
1158:
1159: l_user_id := fnd_global.user_id;
1160: l_login_id := fnd_global.login_id;
1161:
1162: -- doing bulk insert
1163: FORALL l_count IN 1..l_bid_number_insertcol.COUNT
1164: INSERT INTO pon_award_allocations(bid_number, bid_line_number, orig_req_line_id, orig_req_header_id, allocated_qty, split_req_line_id, auction_header_id, created_by, last_update_date, last_updated_by, last_update_login, creation_date)

Line 1704: avalue => fnd_global.user_name);

1700: -- Bug 4456420: Set initiator to current logged in user
1701: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1702: itemkey => x_itemkey,
1703: aname => 'ORIGIN_USER_NAME',
1704: avalue => fnd_global.user_name);
1705:
1706:
1707: x_progress := '30: START_PO_WORKFLOW: Kicking off StartProcess';
1708: log_message(x_itemtype || ' ' ||x_progress);

Line 1713: owner => fnd_global.user_name);

1709:
1710: -- Bug 4295915: Set the workflow owner
1711: wf_engine.SetItemOwner(itemtype => x_itemtype,
1712: itemkey => x_itemkey,
1713: owner => fnd_global.user_name);
1714:
1715: wf_engine.StartProcess(itemtype => x_itemtype,
1716: itemkey => x_itemkey );
1717:

Line 3468: INSERT_IP_DESCRIPTORS(p_auction_header_id, p_bid_number, x_interface_header_id, p_user_id, fnd_global.login_id, l_batch_start, l_batch_end);

3464:
3465: log_message('Inserting iP Descriptors for lines: ' || l_batch_start || ' to ' || l_batch_end);
3466:
3467:
3468: INSERT_IP_DESCRIPTORS(p_auction_header_id, p_bid_number, x_interface_header_id, p_user_id, fnd_global.login_id, l_batch_start, l_batch_end);
3469:
3470: log_message('inserting blanket price break information');
3471:
3472: -- Insert Price Break information

Line 3600: fnd_global.login_id -- last_update_login

3596: sysdate, -- last_update_date
3597: p_user_id, -- last_updated_by
3598: sysdate, -- creation_date,
3599: p_user_id, -- created_by
3600: fnd_global.login_id -- last_update_login
3601: FROM pon_price_differentials ppd,
3602: pon_bid_item_prices pbip,
3603: pon_bid_price_differentials pbpd,
3604: pon_auction_headers_all pah,

Line 3653: fnd_global.login_id -- last_update_login

3649: sysdate, -- last_update_date
3650: p_user_id, -- last_updated_by
3651: sysdate, -- creation_date,
3652: p_user_id, -- created_by
3653: fnd_global.login_id -- last_update_login
3654: FROM pon_price_differentials ppd,
3655: pon_bid_item_prices pbip,
3656: (select pbpd.bid_number, pbpd.line_number,
3657: pbpd.shipment_number, pbs.auction_shipment_number,

Line 4769: fnd_global.user_id,

4765: TO_CHAR(x_po_header_id) document_number,
4766: pocd.created_by,
4767: pocd.attach_pri_key,
4768: sysdate,
4769: fnd_global.user_id,
4770: sysdate,
4771: fnd_global.login_id
4772: FROM pon_orca_cert_details pocd, po_headers_all pha, pon_auction_headers_all paha
4773: WHERE pocd.document_number = paha.document_number

Line 4771: fnd_global.login_id

4767: pocd.attach_pri_key,
4768: sysdate,
4769: fnd_global.user_id,
4770: sysdate,
4771: fnd_global.login_id
4772: FROM pon_orca_cert_details pocd, po_headers_all pha, pon_auction_headers_all paha
4773: WHERE pocd.document_number = paha.document_number
4774: AND paha.auction_header_id = p_auction_header_id
4775: AND pha.po_header_id = x_po_header_id

Line 4877: fnd_global.APPS_INITIALIZE (p_user_id, x_responsibility_id, x_application_id);

4873: FND_PROFILE.GET('RESP_ID', x_responsibility_id);
4874:
4875: FND_PROFILE.GET('RESP_APPL_ID', x_application_id);
4876:
4877: fnd_global.APPS_INITIALIZE (p_user_id, x_responsibility_id, x_application_id);
4878:
4879: -- Get the current policy
4880: v_old_policy := mo_global.get_access_mode();
4881: v_old_org_id := mo_global.get_current_org_id();

Line 5215: newline := fnd_global.newline;

5211: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
5212: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
5213: IF (display_type = 'text/plain') THEN
5214: document_type := 'text/plain';
5215: newline := fnd_global.newline;
5216: beginBold := '';
5217: endBold := '';
5218: ELSE
5219: document_type := 'text/html';

Line 5389: newline := fnd_global.newline;

5385: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
5386:
5387: IF (display_type = 'text/plain') THEN
5388: document_type := 'text/plain';
5389: newline := fnd_global.newline;
5390: beginBold := '';
5391: endBold := '';
5392: ELSE
5393: document_type := 'text/html';

Line 6049: l_user_id := fnd_global.user_id;

6045: x_progress := ++l_progress || l_api_name || ' : IN PARAMETERS : ' || p_auction_header_id;
6046: log_message(x_progress);
6047: end if;
6048:
6049: l_user_id := fnd_global.user_id;
6050: l_login_id := fnd_global.login_id;
6051:
6052: if(l_debug_enabled = 'Y') then
6053: x_progress := ++l_progress || l_api_name || ' : l_user_id : ' || l_user_id;

Line 6050: l_login_id := fnd_global.login_id;

6046: log_message(x_progress);
6047: end if;
6048:
6049: l_user_id := fnd_global.user_id;
6050: l_login_id := fnd_global.login_id;
6051:
6052: if(l_debug_enabled = 'Y') then
6053: x_progress := ++l_progress || l_api_name || ' : l_user_id : ' || l_user_id;
6054: log_message(x_progress);