DBA Data[Home] [Help]

APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on FND_GLOBAL

Line 1788: , FND_GLOBAL.user_id -- LAST_UPDATED_BY

1784: )
1785: =
1786: (SELECT
1787: SYSDATE -- LAST_UPDATE_DATE
1788: , FND_GLOBAL.user_id -- LAST_UPDATED_BY
1789: , FND_GLOBAL.login_id -- LAST_UPDATE_LOGIN
1790: , LDETS.order_qty_operand
1791: , LDETS.operand_value
1792: , LDETS.order_qty_adj_amt

Line 1789: , FND_GLOBAL.login_id -- LAST_UPDATE_LOGIN

1785: =
1786: (SELECT
1787: SYSDATE -- LAST_UPDATE_DATE
1788: , FND_GLOBAL.user_id -- LAST_UPDATED_BY
1789: , FND_GLOBAL.login_id -- LAST_UPDATE_LOGIN
1790: , LDETS.order_qty_operand
1791: , LDETS.operand_value
1792: , LDETS.order_qty_adj_amt
1793: , LDETS.adjustment_amount

Line 1960: , FND_GLOBAL.user_id -- CREATED_BY

1956: p_draft_id --DRAFT_ID
1957: , po_price_adjustments_s.nextval -- PRICE_ADJUSTMENT_ID
1958: , LDETS.line_detail_index --ADJ_LINE_NUM
1959: , SYSDATE -- CREATION_DATE
1960: , FND_GLOBAL.user_id -- CREATED_BY
1961: , SYSDATE -- LAST_UPDATE_DATE
1962: , FND_GLOBAL.user_id -- LAST_UPDATED_BY
1963: , FND_GLOBAL.login_id -- LAST_UPDATE_LOGIN
1964: , NULL -- PROGRAM_APPLICATION_ID

Line 1962: , FND_GLOBAL.user_id -- LAST_UPDATED_BY

1958: , LDETS.line_detail_index --ADJ_LINE_NUM
1959: , SYSDATE -- CREATION_DATE
1960: , FND_GLOBAL.user_id -- CREATED_BY
1961: , SYSDATE -- LAST_UPDATE_DATE
1962: , FND_GLOBAL.user_id -- LAST_UPDATED_BY
1963: , FND_GLOBAL.login_id -- LAST_UPDATE_LOGIN
1964: , NULL -- PROGRAM_APPLICATION_ID
1965: , NULL -- PROGRAM_ID
1966: , NULL -- PROGRAM_UPDATE_DATE

Line 1963: , FND_GLOBAL.login_id -- LAST_UPDATE_LOGIN

1959: , SYSDATE -- CREATION_DATE
1960: , FND_GLOBAL.user_id -- CREATED_BY
1961: , SYSDATE -- LAST_UPDATE_DATE
1962: , FND_GLOBAL.user_id -- LAST_UPDATED_BY
1963: , FND_GLOBAL.login_id -- LAST_UPDATE_LOGIN
1964: , NULL -- PROGRAM_APPLICATION_ID
1965: , NULL -- PROGRAM_ID
1966: , NULL -- PROGRAM_UPDATE_DATE
1967: , NULL -- REQUEST_ID

Line 2210: , fnd_global.user_id

2206: , l_adj_id_tbl(i) --ADJ.PRICE_ADJUSTMENT_ID
2207: , QPLAT.context
2208: , QPLAT.attribute
2209: , SYSDATE
2210: , fnd_global.user_id
2211: , SYSDATE
2212: , fnd_global.user_id
2213: , fnd_global.login_id
2214: , NULL

Line 2212: , fnd_global.user_id

2208: , QPLAT.attribute
2209: , SYSDATE
2210: , fnd_global.user_id
2211: , SYSDATE
2212: , fnd_global.user_id
2213: , fnd_global.login_id
2214: , NULL
2215: , NULL
2216: , NULL

Line 2213: , fnd_global.login_id

2209: , SYSDATE
2210: , fnd_global.user_id
2211: , SYSDATE
2212: , fnd_global.user_id
2213: , fnd_global.login_id
2214: , NULL
2215: , NULL
2216: , NULL
2217: , NULL

Line 2292: , fnd_global.user_id

2288: , ADJ.price_adjustment_id
2289: , QPLAT.context
2290: , QPLAT.attribute
2291: , SYSDATE
2292: , fnd_global.user_id
2293: , SYSDATE
2294: , fnd_global.user_id
2295: , fnd_global.login_id
2296: , NULL

Line 2294: , fnd_global.user_id

2290: , QPLAT.attribute
2291: , SYSDATE
2292: , fnd_global.user_id
2293: , SYSDATE
2294: , fnd_global.user_id
2295: , fnd_global.login_id
2296: , NULL
2297: , NULL
2298: , NULL

Line 2295: , fnd_global.login_id

2291: , SYSDATE
2292: , fnd_global.user_id
2293: , SYSDATE
2294: , fnd_global.user_id
2295: , fnd_global.login_id
2296: , NULL
2297: , NULL
2298: , NULL
2299: , NULL

Line 2401: , fnd_global.user_id

2397: , ADJD.price_adjustment_id
2398: , PRA.pricing_attribute_context
2399: , PRA.pricing_attribute
2400: , SYSDATE
2401: , fnd_global.user_id
2402: , SYSDATE
2403: , fnd_global.user_id
2404: , fnd_global.login_id
2405: , NULL

Line 2403: , fnd_global.user_id

2399: , PRA.pricing_attribute
2400: , SYSDATE
2401: , fnd_global.user_id
2402: , SYSDATE
2403: , fnd_global.user_id
2404: , fnd_global.login_id
2405: , NULL
2406: , NULL
2407: , NULL

Line 2404: , fnd_global.login_id

2400: , SYSDATE
2401: , fnd_global.user_id
2402: , SYSDATE
2403: , fnd_global.user_id
2404: , fnd_global.login_id
2405: , NULL
2406: , NULL
2407: , NULL
2408: , NULL

Line 2461: , fnd_global.user_id

2457: , ADJD.price_adjustment_id
2458: , QUAL.qualifier_context
2459: , QUAL.qualifier_attribute
2460: , SYSDATE
2461: , fnd_global.user_id
2462: , SYSDATE
2463: , fnd_global.user_id
2464: , fnd_global.login_id
2465: , NULL

Line 2463: , fnd_global.user_id

2459: , QUAL.qualifier_attribute
2460: , SYSDATE
2461: , fnd_global.user_id
2462: , SYSDATE
2463: , fnd_global.user_id
2464: , fnd_global.login_id
2465: , NULL
2466: , NULL
2467: , NULL

Line 2464: , fnd_global.login_id

2460: , SYSDATE
2461: , fnd_global.user_id
2462: , SYSDATE
2463: , fnd_global.user_id
2464: , fnd_global.login_id
2465: , NULL
2466: , NULL
2467: , NULL
2468: , NULL

Line 2684: l_po_price_adjustment_record.created_by := fnd_global.user_id;

2680: INTO l_po_price_adjustment_record.price_adjustment_id
2681: FROM SYS.DUAL;
2682:
2683: --reset Standard and other columns
2684: l_po_price_adjustment_record.created_by := fnd_global.user_id;
2685: l_po_price_adjustment_record.creation_date := SYSDATE;
2686: l_po_price_adjustment_record.last_updated_by := fnd_global.user_id;
2687: l_po_price_adjustment_record.last_update_date := SYSDATE;
2688: l_po_price_adjustment_record.last_update_login := fnd_global.login_id;

Line 2686: l_po_price_adjustment_record.last_updated_by := fnd_global.user_id;

2682:
2683: --reset Standard and other columns
2684: l_po_price_adjustment_record.created_by := fnd_global.user_id;
2685: l_po_price_adjustment_record.creation_date := SYSDATE;
2686: l_po_price_adjustment_record.last_updated_by := fnd_global.user_id;
2687: l_po_price_adjustment_record.last_update_date := SYSDATE;
2688: l_po_price_adjustment_record.last_update_login := fnd_global.login_id;
2689:
2690: l_po_price_adjustment_record.program_application_id := NULL;

Line 2688: l_po_price_adjustment_record.last_update_login := fnd_global.login_id;

2684: l_po_price_adjustment_record.created_by := fnd_global.user_id;
2685: l_po_price_adjustment_record.creation_date := SYSDATE;
2686: l_po_price_adjustment_record.last_updated_by := fnd_global.user_id;
2687: l_po_price_adjustment_record.last_update_date := SYSDATE;
2688: l_po_price_adjustment_record.last_update_login := fnd_global.login_id;
2689:
2690: l_po_price_adjustment_record.program_application_id := NULL;
2691: l_po_price_adjustment_record.program_id := NULL;
2692: l_po_price_adjustment_record.program_update_date := NULL;

Line 2743: , fnd_global.user_id

2739: l_po_price_adjustment_record.price_adjustment_id --newly copied price_adjustment_id
2740: , ATTR.pricing_context
2741: , ATTR.pricing_attribute
2742: , SYSDATE
2743: , fnd_global.user_id
2744: , SYSDATE
2745: , fnd_global.user_id
2746: , fnd_global.login_id
2747: , NULL

Line 2745: , fnd_global.user_id

2741: , ATTR.pricing_attribute
2742: , SYSDATE
2743: , fnd_global.user_id
2744: , SYSDATE
2745: , fnd_global.user_id
2746: , fnd_global.login_id
2747: , NULL
2748: , NULL
2749: , NULL

Line 2746: , fnd_global.login_id

2742: , SYSDATE
2743: , fnd_global.user_id
2744: , SYSDATE
2745: , fnd_global.user_id
2746: , fnd_global.login_id
2747: , NULL
2748: , NULL
2749: , NULL
2750: , NULL

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

3025: )
3026: (SELECT p_draft_id
3027: , ASOC.price_adjustment_id
3028: , SYSDATE --p_Line_Adj_Assoc_Rec.creation_date
3029: , fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
3030: , SYSDATE --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
3031: , fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
3032: , fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
3033: , NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID

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

3027: , ASOC.price_adjustment_id
3028: , SYSDATE --p_Line_Adj_Assoc_Rec.creation_date
3029: , fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
3030: , SYSDATE --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
3031: , fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
3032: , fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
3033: , NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
3034: , NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
3035: , NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE

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

3028: , SYSDATE --p_Line_Adj_Assoc_Rec.creation_date
3029: , fnd_global.user_id --p_Line_Adj_Assoc_Rec.CREATED_BY
3030: , SYSDATE --p_Line_Adj_Assoc_Rec.LAST_UPDATE_DATE
3031: , fnd_global.user_id --p_Line_Adj_Assoc_Rec.LAST_UPDATED_BY
3032: , fnd_global.login_id --p_Line_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
3033: , NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
3034: , NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
3035: , NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
3036: , NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID

Line 3087: l_po_price_adjustment_record.created_by := fnd_global.user_id;

3083: INTO l_po_price_adjustment_record.price_adjustment_id
3084: FROM SYS.DUAL;
3085:
3086: --reset Standard columns
3087: l_po_price_adjustment_record.created_by := fnd_global.user_id;
3088: l_po_price_adjustment_record.creation_date := SYSDATE;
3089: l_po_price_adjustment_record.last_updated_by := fnd_global.user_id;
3090: l_po_price_adjustment_record.last_update_date := SYSDATE;
3091: l_po_price_adjustment_record.last_update_login := fnd_global.login_id;

Line 3089: l_po_price_adjustment_record.last_updated_by := fnd_global.user_id;

3085:
3086: --reset Standard columns
3087: l_po_price_adjustment_record.created_by := fnd_global.user_id;
3088: l_po_price_adjustment_record.creation_date := SYSDATE;
3089: l_po_price_adjustment_record.last_updated_by := fnd_global.user_id;
3090: l_po_price_adjustment_record.last_update_date := SYSDATE;
3091: l_po_price_adjustment_record.last_update_login := fnd_global.login_id;
3092:
3093: l_po_price_adjustment_record.program_application_id := NULL;

Line 3091: l_po_price_adjustment_record.last_update_login := fnd_global.login_id;

3087: l_po_price_adjustment_record.created_by := fnd_global.user_id;
3088: l_po_price_adjustment_record.creation_date := SYSDATE;
3089: l_po_price_adjustment_record.last_updated_by := fnd_global.user_id;
3090: l_po_price_adjustment_record.last_update_date := SYSDATE;
3091: l_po_price_adjustment_record.last_update_login := fnd_global.login_id;
3092:
3093: l_po_price_adjustment_record.program_application_id := NULL;
3094: l_po_price_adjustment_record.program_id := NULL;
3095: l_po_price_adjustment_record.program_update_date := NULL;

Line 3149: , fnd_global.user_id

3145: , l_po_price_adjustment_record.price_adjustment_id --newly copied price_adjustment_id
3146: , ATTRV.pricing_context
3147: , ATTRV.pricing_attribute
3148: , SYSDATE
3149: , fnd_global.user_id
3150: , SYSDATE
3151: , fnd_global.user_id
3152: , fnd_global.login_id
3153: , NULL

Line 3151: , fnd_global.user_id

3147: , ATTRV.pricing_attribute
3148: , SYSDATE
3149: , fnd_global.user_id
3150: , SYSDATE
3151: , fnd_global.user_id
3152: , fnd_global.login_id
3153: , NULL
3154: , NULL
3155: , NULL

Line 3152: , fnd_global.login_id

3148: , SYSDATE
3149: , fnd_global.user_id
3150: , SYSDATE
3151: , fnd_global.user_id
3152: , fnd_global.login_id
3153: , NULL
3154: , NULL
3155: , NULL
3156: , NULL