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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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;
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;
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
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
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
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
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
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
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;
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;
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;
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
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
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