APPS.OE_RETROBILL_PVT dependencies on FND_GLOBAL

Line 892: , CREATED_BY = nvl(p_retrobill_request_rec.created_by,fnd_global.user_id)

888: , EXECUTION_DATE= nvl(p_retrobill_request_rec.execution_date,SYSDATE)
889: , INVENTORY_ITEM_ID= p_retrobill_request_rec.inventory_item_id
890: , SOLD_TO_ORG_ID = p_retrobill_request_rec.sold_to_org_id
891: , CREATION_DATE = nvl(p_retrobill_request_rec.creation_date,SYSDATE)
892: , CREATED_BY = nvl(p_retrobill_request_rec.created_by,fnd_global.user_id)
893: , LAST_UPDATE_DATE = nvl(p_retrobill_request_rec.last_update_date,SYSDATE)
894: , LAST_UPDATED_BY = nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id)
895: , LAST_UPDATE_LOGIN= nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id)
896: , REQUEST_ID = p_retrobill_request_rec.request_id

Line 894: , LAST_UPDATED_BY = nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id)

890: , SOLD_TO_ORG_ID = p_retrobill_request_rec.sold_to_org_id
891: , CREATION_DATE = nvl(p_retrobill_request_rec.creation_date,SYSDATE)
892: , CREATED_BY = nvl(p_retrobill_request_rec.created_by,fnd_global.user_id)
893: , LAST_UPDATE_DATE = nvl(p_retrobill_request_rec.last_update_date,SYSDATE)
894: , LAST_UPDATED_BY = nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id)
895: , LAST_UPDATE_LOGIN= nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id)
896: , REQUEST_ID = p_retrobill_request_rec.request_id
897: , PROGRAM_APPLICATION_ID= nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id)
898: , PROGRAM_ID = p_retrobill_request_rec.program_id

Line 895: , LAST_UPDATE_LOGIN= nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id)

891: , CREATION_DATE = nvl(p_retrobill_request_rec.creation_date,SYSDATE)
892: , CREATED_BY = nvl(p_retrobill_request_rec.created_by,fnd_global.user_id)
893: , LAST_UPDATE_DATE = nvl(p_retrobill_request_rec.last_update_date,SYSDATE)
894: , LAST_UPDATED_BY = nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id)
895: , LAST_UPDATE_LOGIN= nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id)
896: , REQUEST_ID = p_retrobill_request_rec.request_id
897: , PROGRAM_APPLICATION_ID= nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id)
898: , PROGRAM_ID = p_retrobill_request_rec.program_id
899: , PROGRAM_UPDATED_DATE= p_retrobill_request_rec.program_updated_date

Line 897: , PROGRAM_APPLICATION_ID= nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id)

893: , LAST_UPDATE_DATE = nvl(p_retrobill_request_rec.last_update_date,SYSDATE)
894: , LAST_UPDATED_BY = nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id)
895: , LAST_UPDATE_LOGIN= nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id)
896: , REQUEST_ID = p_retrobill_request_rec.request_id
897: , PROGRAM_APPLICATION_ID= nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id)
898: , PROGRAM_ID = p_retrobill_request_rec.program_id
899: , PROGRAM_UPDATED_DATE= p_retrobill_request_rec.program_updated_date
900: Where retrobill_request_id = p_retrobill_request_rec.retrobill_request_id;
901:

Line 1396: nvl(p_retrobill_request_rec.created_by,fnd_global.user_id),

1392: nvl(p_retrobill_request_rec.execution_date,SYSDATE),
1393: p_retrobill_request_rec.inventory_item_id,
1394: p_retrobill_request_rec.sold_to_org_id,
1395: nvl(p_retrobill_request_rec.creation_date,SYSDATE),
1396: nvl(p_retrobill_request_rec.created_by,fnd_global.user_id),
1397: nvl(p_retrobill_request_rec.last_update_date,SYSDATE),
1398: nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id),
1399: nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id),
1400: p_retrobill_request_rec.request_id,

Line 1398: nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id),

1394: p_retrobill_request_rec.sold_to_org_id,
1395: nvl(p_retrobill_request_rec.creation_date,SYSDATE),
1396: nvl(p_retrobill_request_rec.created_by,fnd_global.user_id),
1397: nvl(p_retrobill_request_rec.last_update_date,SYSDATE),
1398: nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id),
1399: nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id),
1400: p_retrobill_request_rec.request_id,
1401: nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id),
1402: p_retrobill_request_rec.program_id,

Line 1399: nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id),

1395: nvl(p_retrobill_request_rec.creation_date,SYSDATE),
1396: nvl(p_retrobill_request_rec.created_by,fnd_global.user_id),
1397: nvl(p_retrobill_request_rec.last_update_date,SYSDATE),
1398: nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id),
1399: nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id),
1400: p_retrobill_request_rec.request_id,
1401: nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id),
1402: p_retrobill_request_rec.program_id,
1403: p_retrobill_request_rec.program_updated_date);

Line 1401: nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id),

1397: nvl(p_retrobill_request_rec.last_update_date,SYSDATE),
1398: nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id),
1399: nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id),
1400: p_retrobill_request_rec.request_id,
1401: nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id),
1402: p_retrobill_request_rec.program_id,
1403: p_retrobill_request_rec.program_updated_date);
1404:
1405: Exception

Line 1833: , fnd_global.user_id --p_Line_Adj_rec.created_by

1829: )
1830: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
1831: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
1832: , sysdate --p_Line_Adj_rec.creation_date
1833: , fnd_global.user_id --p_Line_Adj_rec.created_by
1834: , sysdate --p_Line_Adj_rec.last_update_date
1835: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
1836: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
1837: , NULL --p_Line_Adj_rec.program_application_id

Line 1835: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

1831: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
1832: , sysdate --p_Line_Adj_rec.creation_date
1833: , fnd_global.user_id --p_Line_Adj_rec.created_by
1834: , sysdate --p_Line_Adj_rec.last_update_date
1835: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
1836: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
1837: , NULL --p_Line_Adj_rec.program_application_id
1838: , NULL --p_Line_Adj_rec.program_id
1839: , NULL --p_Line_Adj_rec.program_update_date

Line 1836: , fnd_global.login_id --p_Line_Adj_rec.last_update_login

1832: , sysdate --p_Line_Adj_rec.creation_date
1833: , fnd_global.user_id --p_Line_Adj_rec.created_by
1834: , sysdate --p_Line_Adj_rec.last_update_date
1835: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
1836: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
1837: , NULL --p_Line_Adj_rec.program_application_id
1838: , NULL --p_Line_Adj_rec.program_id
1839: , NULL --p_Line_Adj_rec.program_update_date
1840: , NULL --p_Line_Adj_rec.request_id

Line 2211: , fnd_global.user_id --p_Line_Adj_rec.created_by

2207: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2208: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2209: ldets.price_adjustment_id
2210: , sysdate --p_Line_Adj_rec.creation_date
2211: , fnd_global.user_id --p_Line_Adj_rec.created_by
2212: , sysdate --p_Line_Adj_rec.last_update_date
2213: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2214: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2215: , NULL --p_Line_Adj_rec.program_application_id

Line 2213: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

2209: ldets.price_adjustment_id
2210: , sysdate --p_Line_Adj_rec.creation_date
2211: , fnd_global.user_id --p_Line_Adj_rec.created_by
2212: , sysdate --p_Line_Adj_rec.last_update_date
2213: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2214: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2215: , NULL --p_Line_Adj_rec.program_application_id
2216: , NULL --p_Line_Adj_rec.program_id
2217: , NULL --p_Line_Adj_rec.program_update_date

Line 2214: , fnd_global.login_id --p_Line_Adj_rec.last_update_login

2210: , sysdate --p_Line_Adj_rec.creation_date
2211: , fnd_global.user_id --p_Line_Adj_rec.created_by
2212: , sysdate --p_Line_Adj_rec.last_update_date
2213: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2214: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2215: , NULL --p_Line_Adj_rec.program_application_id
2216: , NULL --p_Line_Adj_rec.program_id
2217: , NULL --p_Line_Adj_rec.program_update_date
2218: , NULL --p_Line_Adj_rec.request_id

Line 2357: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY

2353: )
2354: (SELECT /*+ ORDERED USE_NL(QPL ADJ RADJ) */
2355: LDET.price_adjustment_id
2356: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2357: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2358: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2359: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2360: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2361: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID

Line 2359: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY

2355: LDET.price_adjustment_id
2356: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2357: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2358: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2359: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2360: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2361: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2362: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2363: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE

Line 2360: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN

2356: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2357: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2358: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2359: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2360: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2361: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2362: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2363: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
2364: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID

Line 2505: , fnd_global.user_id --p_Line_Adj_rec.created_by

2501: )
2502: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2503: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2504: , sysdate --p_Line_Adj_rec.creation_date
2505: , fnd_global.user_id --p_Line_Adj_rec.created_by
2506: , sysdate --p_Line_Adj_rec.last_update_date
2507: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2508: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2509: , NULL --p_Line_Adj_rec.program_application_id

Line 2507: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by

2503: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2504: , sysdate --p_Line_Adj_rec.creation_date
2505: , fnd_global.user_id --p_Line_Adj_rec.created_by
2506: , sysdate --p_Line_Adj_rec.last_update_date
2507: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2508: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2509: , NULL --p_Line_Adj_rec.program_application_id
2510: , NULL --p_Line_Adj_rec.program_id
2511: , NULL --p_Line_Adj_rec.program_update_date

Line 2508: , fnd_global.login_id --p_Line_Adj_rec.last_update_login

2504: , sysdate --p_Line_Adj_rec.creation_date
2505: , fnd_global.user_id --p_Line_Adj_rec.created_by
2506: , sysdate --p_Line_Adj_rec.last_update_date
2507: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2508: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2509: , NULL --p_Line_Adj_rec.program_application_id
2510: , NULL --p_Line_Adj_rec.program_id
2511: , NULL --p_Line_Adj_rec.program_update_date
2512: , NULL --p_Line_Adj_rec.request_id