APPS.OE_RETROBILL_PVT dependencies on FND_GLOBAL

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

900: , EXECUTION_DATE= nvl(p_retrobill_request_rec.execution_date,SYSDATE)
901: , INVENTORY_ITEM_ID= p_retrobill_request_rec.inventory_item_id
902: , SOLD_TO_ORG_ID = p_retrobill_request_rec.sold_to_org_id
903: , CREATION_DATE = nvl(p_retrobill_request_rec.creation_date,SYSDATE)
904: , CREATED_BY = nvl(p_retrobill_request_rec.created_by,fnd_global.user_id)
905: , LAST_UPDATE_DATE = nvl(p_retrobill_request_rec.last_update_date,SYSDATE)
906: , LAST_UPDATED_BY = nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id)
907: , LAST_UPDATE_LOGIN= nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id)
908: , REQUEST_ID = p_retrobill_request_rec.request_id

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

902: , SOLD_TO_ORG_ID = p_retrobill_request_rec.sold_to_org_id
903: , CREATION_DATE = nvl(p_retrobill_request_rec.creation_date,SYSDATE)
904: , CREATED_BY = nvl(p_retrobill_request_rec.created_by,fnd_global.user_id)
905: , LAST_UPDATE_DATE = nvl(p_retrobill_request_rec.last_update_date,SYSDATE)
906: , LAST_UPDATED_BY = nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id)
907: , LAST_UPDATE_LOGIN= nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id)
908: , REQUEST_ID = p_retrobill_request_rec.request_id
909: , PROGRAM_APPLICATION_ID= nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id)
910: , PROGRAM_ID = p_retrobill_request_rec.program_id

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

903: , CREATION_DATE = nvl(p_retrobill_request_rec.creation_date,SYSDATE)
904: , CREATED_BY = nvl(p_retrobill_request_rec.created_by,fnd_global.user_id)
905: , LAST_UPDATE_DATE = nvl(p_retrobill_request_rec.last_update_date,SYSDATE)
906: , LAST_UPDATED_BY = nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id)
907: , LAST_UPDATE_LOGIN= nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id)
908: , REQUEST_ID = p_retrobill_request_rec.request_id
909: , PROGRAM_APPLICATION_ID= nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id)
910: , PROGRAM_ID = p_retrobill_request_rec.program_id
911: , PROGRAM_UPDATED_DATE= p_retrobill_request_rec.program_updated_date

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

905: , LAST_UPDATE_DATE = nvl(p_retrobill_request_rec.last_update_date,SYSDATE)
906: , LAST_UPDATED_BY = nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id)
907: , LAST_UPDATE_LOGIN= nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id)
908: , REQUEST_ID = p_retrobill_request_rec.request_id
909: , PROGRAM_APPLICATION_ID= nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id)
910: , PROGRAM_ID = p_retrobill_request_rec.program_id
911: , PROGRAM_UPDATED_DATE= p_retrobill_request_rec.program_updated_date
912: Where retrobill_request_id = p_retrobill_request_rec.retrobill_request_id;
913:

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

1691: nvl(p_retrobill_request_rec.execution_date,SYSDATE),
1692: p_retrobill_request_rec.inventory_item_id,
1693: p_retrobill_request_rec.sold_to_org_id,
1694: nvl(p_retrobill_request_rec.creation_date,SYSDATE),
1695: nvl(p_retrobill_request_rec.created_by,fnd_global.user_id),
1696: nvl(p_retrobill_request_rec.last_update_date,SYSDATE),
1697: nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id),
1698: nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id),
1699: p_retrobill_request_rec.request_id,

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

1693: p_retrobill_request_rec.sold_to_org_id,
1694: nvl(p_retrobill_request_rec.creation_date,SYSDATE),
1695: nvl(p_retrobill_request_rec.created_by,fnd_global.user_id),
1696: nvl(p_retrobill_request_rec.last_update_date,SYSDATE),
1697: nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id),
1698: nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id),
1699: p_retrobill_request_rec.request_id,
1700: nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id),
1701: p_retrobill_request_rec.program_id,

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

1694: nvl(p_retrobill_request_rec.creation_date,SYSDATE),
1695: nvl(p_retrobill_request_rec.created_by,fnd_global.user_id),
1696: nvl(p_retrobill_request_rec.last_update_date,SYSDATE),
1697: nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id),
1698: nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id),
1699: p_retrobill_request_rec.request_id,
1700: nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id),
1701: p_retrobill_request_rec.program_id,
1702: p_retrobill_request_rec.program_updated_date);

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

1696: nvl(p_retrobill_request_rec.last_update_date,SYSDATE),
1697: nvl(p_retrobill_request_rec.last_updated_by,fnd_global.user_id),
1698: nvl(p_retrobill_request_rec.last_update_login,fnd_global.login_id),
1699: p_retrobill_request_rec.request_id,
1700: nvl(p_retrobill_request_rec.program_application_id,fnd_global.prog_appl_id),
1701: p_retrobill_request_rec.program_id,
1702: p_retrobill_request_rec.program_updated_date);
1703:
1704: Exception

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

2167: )
2168: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2169: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2170: , sysdate --p_Line_Adj_rec.creation_date
2171: , fnd_global.user_id --p_Line_Adj_rec.created_by
2172: , sysdate --p_Line_Adj_rec.last_update_date
2173: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2174: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2175: , NULL --p_Line_Adj_rec.program_application_id

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

2169: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2170: , sysdate --p_Line_Adj_rec.creation_date
2171: , fnd_global.user_id --p_Line_Adj_rec.created_by
2172: , sysdate --p_Line_Adj_rec.last_update_date
2173: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2174: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2175: , NULL --p_Line_Adj_rec.program_application_id
2176: , NULL --p_Line_Adj_rec.program_id
2177: , NULL --p_Line_Adj_rec.program_update_date

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

2170: , sysdate --p_Line_Adj_rec.creation_date
2171: , fnd_global.user_id --p_Line_Adj_rec.created_by
2172: , sysdate --p_Line_Adj_rec.last_update_date
2173: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2174: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2175: , NULL --p_Line_Adj_rec.program_application_id
2176: , NULL --p_Line_Adj_rec.program_id
2177: , NULL --p_Line_Adj_rec.program_update_date
2178: , NULL --p_Line_Adj_rec.request_id

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

2545: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2546: -- oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2547: ldets.price_adjustment_id
2548: , sysdate --p_Line_Adj_rec.creation_date
2549: , fnd_global.user_id --p_Line_Adj_rec.created_by
2550: , sysdate --p_Line_Adj_rec.last_update_date
2551: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2552: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2553: , NULL --p_Line_Adj_rec.program_application_id

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

2547: ldets.price_adjustment_id
2548: , sysdate --p_Line_Adj_rec.creation_date
2549: , fnd_global.user_id --p_Line_Adj_rec.created_by
2550: , sysdate --p_Line_Adj_rec.last_update_date
2551: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2552: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2553: , NULL --p_Line_Adj_rec.program_application_id
2554: , NULL --p_Line_Adj_rec.program_id
2555: , NULL --p_Line_Adj_rec.program_update_date

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

2548: , sysdate --p_Line_Adj_rec.creation_date
2549: , fnd_global.user_id --p_Line_Adj_rec.created_by
2550: , sysdate --p_Line_Adj_rec.last_update_date
2551: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2552: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2553: , NULL --p_Line_Adj_rec.program_application_id
2554: , NULL --p_Line_Adj_rec.program_id
2555: , NULL --p_Line_Adj_rec.program_update_date
2556: , NULL --p_Line_Adj_rec.request_id

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

2691: )
2692: (SELECT /*+ ORDERED USE_NL(QPL ADJ RADJ) */
2693: LDET.price_adjustment_id
2694: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2695: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2696: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2697: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2698: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2699: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID

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

2693: LDET.price_adjustment_id
2694: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2695: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2696: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2697: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2698: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2699: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2700: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2701: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE

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

2694: ,sysdate --p_Line_Adj_Assoc_Rec.creation_date
2695: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
2696: ,sysdate --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
2697: ,fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
2698: ,fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
2699: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2700: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2701: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
2702: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID

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

2839: )
2840: ( SELECT /*+ ORDERED USE_NL(ldets lines qh) */
2841: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2842: , sysdate --p_Line_Adj_rec.creation_date
2843: , fnd_global.user_id --p_Line_Adj_rec.created_by
2844: , sysdate --p_Line_Adj_rec.last_update_date
2845: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2846: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2847: , NULL --p_Line_Adj_rec.program_application_id

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

2841: oe_price_adjustments_s.nextval -- p_Line_Adj_rec.price_adjustment_id
2842: , sysdate --p_Line_Adj_rec.creation_date
2843: , fnd_global.user_id --p_Line_Adj_rec.created_by
2844: , sysdate --p_Line_Adj_rec.last_update_date
2845: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2846: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2847: , NULL --p_Line_Adj_rec.program_application_id
2848: , NULL --p_Line_Adj_rec.program_id
2849: , NULL --p_Line_Adj_rec.program_update_date

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

2842: , sysdate --p_Line_Adj_rec.creation_date
2843: , fnd_global.user_id --p_Line_Adj_rec.created_by
2844: , sysdate --p_Line_Adj_rec.last_update_date
2845: , fnd_global.user_id --p_Line_Adj_rec.last_updated_by
2846: , fnd_global.login_id --p_Line_Adj_rec.last_update_login
2847: , NULL --p_Line_Adj_rec.program_application_id
2848: , NULL --p_Line_Adj_rec.program_id
2849: , NULL --p_Line_Adj_rec.program_update_date
2850: , NULL --p_Line_Adj_rec.request_id