DBA Data[Home] [Help]

APPS.PON_CLM_CLO_UTIL_PKG dependencies on FND_GLOBAL

Line 353: last_updated_by = FND_GLOBAL.USER_ID,

349: ELSE 'Y'
350: END
351: ), --
352: last_update_date = SYSDATE,
353: last_updated_by = FND_GLOBAL.USER_ID,
354: last_update_login = FND_GLOBAL.LOGIN_ID
355: where requisition_header_id = x_req_hdr_id
356: and requisition_line_id = rec.requisition_line_id;
357:

Line 354: last_update_login = FND_GLOBAL.LOGIN_ID

350: END
351: ), --
352: last_update_date = SYSDATE,
353: last_updated_by = FND_GLOBAL.USER_ID,
354: last_update_login = FND_GLOBAL.LOGIN_ID
355: where requisition_header_id = x_req_hdr_id
356: and requisition_line_id = rec.requisition_line_id;
357:
358: END LOOP;

Line 425: SELECT fnd_global.user_id INTO l_user_id FROM dual;

421: SELECT (Count(clm_option_num) + 1) INTO l_option_num FROM pon_auction_item_prices_all
422: WHERE auction_header_id = p_auction_header_id
423: AND clm_base_line_num = p_src_line_number;
424:
425: SELECT fnd_global.user_id INTO l_user_id FROM dual;
426:
427:
428:
429: copy_line_information(p_auction_header_id,

Line 566: SELECT fnd_global.user_id INTO l_user_id FROM dual;

562: ELSE
563: l_max_line_number := x_max_line_number;
564: END IF;
565:
566: SELECT fnd_global.user_id INTO l_user_id FROM dual;
567:
568: -- check whether source line is a clin and whethere it is an option
569: SELECT Nvl2(group_line_id,'N','Y'),nvl(group_line_id,l_max_line_number+1), decode(Nvl(clm_option_indicator,'N'),'O','Y','N') INTO l_clin_flag,l_new_group_line_id,l_is_option_copy
570: FROM pon_auction_item_prices_all

Line 628: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

624: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
625: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
626: X_to_pk2_value => to_char(l_line_number),
627: X_created_by => l_user_id, -- CREATED_BY
628: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
629: );
630:
631:
632:

Line 734: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

730: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
731: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE
732: X_to_pk2_value => to_char(l_line_number),
733: X_created_by => l_user_id, -- CREATED_BY
734: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
735: );
736:
737:
738:

Line 1517: fnd_global.login_id

1513: SYSDATE,
1514: p_user_id,
1515: SYSDATE,
1516: p_user_id,
1517: fnd_global.login_id
1518: FROM pon_auc_payments_shipments
1519: WHERE auction_header_id = p_auction_header_id
1520: AND line_number =p_src_line_number );
1521:

Line 1837: AND ORG_ID = Nvl(PO_MOAC_UTILS_PVT.GET_CURRENT_ORG_ID, FND_GLOBAL.ORG_ID);

1833: INTO l_doc_type_dsp
1834: FROM po_document_types_vl
1835: WHERE document_type_code = 'SOLICITATION'
1836: AND document_subtype = 'SOLICITATION'
1837: AND ORG_ID = Nvl(PO_MOAC_UTILS_PVT.GET_CURRENT_ORG_ID, FND_GLOBAL.ORG_ID);
1838:
1839: ELSE
1840:
1841: SELECT Decode(p_caller,'PO_MOD', type_name ||' '|| FND_MESSAGE.GET_STRING('PO','PO_MODIFICATION') ,type_name)

Line 1847: FND_GLOBAL.ORG_ID)

1843: FROM po_document_types_vl pdt,
1844: po_headers_draft_all poh
1845: WHERE pdt.document_type_code IN ('PO', 'PA')
1846: AND pdt.ORG_ID =Nvl(PO_MOAC_UTILS_PVT.GET_CURRENT_ORG_ID,
1847: FND_GLOBAL.ORG_ID)
1848: AND pdt.document_subtype = POH.type_lookup_code
1849: AND poh.draft_id=p_document_id;
1850:
1851:

Line 1873: avalue => fnd_global.user_name);

1869:
1870: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1871: itemkey => l_itemkey,
1872: aname => 'ORIGIN_USER_NAME',
1873: avalue => fnd_global.user_name);
1874:
1875: wf_engine.SetItemOwner(itemtype => l_itemtype,
1876: itemkey => l_itemkey,
1877: owner => fnd_global.user_name );

Line 1877: owner => fnd_global.user_name );

1873: avalue => fnd_global.user_name);
1874:
1875: wf_engine.SetItemOwner(itemtype => l_itemtype,
1876: itemkey => l_itemkey,
1877: owner => fnd_global.user_name );
1878:
1879: wf_engine.StartProcess(itemtype => l_itemtype,
1880: itemkey => l_itemkey );
1881:

Line 1976: SELECT fnd_global.user_id INTO l_user_id FROM dual;

1972: FROM pon_auction_item_prices_all
1973: WHERE auction_header_id = p_auction_header_id
1974: AND line_number = l_src_line_number;
1975:
1976: SELECT fnd_global.user_id INTO l_user_id FROM dual;
1977:
1978: -- check whether source line is a clin and whethere it is an option
1979: SELECT Nvl2(group_line_id, 'N', 'Y'),
1980: NVL(group_line_id, l_max_line_number + 1),

Line 2016: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

2012: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2013: X_to_pk1_value => TO_CHAR(p_auction_header_id), -- PK1_VALUE
2014: X_to_pk2_value => TO_CHAR(l_line_number),
2015: X_created_by => l_user_id, -- CREATED_BY
2016: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
2017: ); */
2018:
2019: IF (NVL(l_info_flags(1), 'N') = 'N') THEN
2020: /*

Line 2143: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN

2139: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
2140: X_to_pk1_value => TO_CHAR(p_auction_header_id), -- PK1_VALUE
2141: X_to_pk2_value => TO_CHAR(l_line_number),
2142: X_created_by => l_user_id, -- CREATED_BY
2143: X_last_update_login => fnd_global.login_id -- LAST_UPDATE_LOGIN
2144: ); */
2145: IF (NVL(l_info_flags(j), 'N') = 'N') THEN
2146: /*
2147: copying attributes