eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_ADJ_PRODUCTS_PKG dependencies on FND_API

Line 47: DECODE(px_offer_adjustment_product_id , FND_API.G_MISS_NUM , NULL, px_offer_adjustment_product_id)

43: , last_update_login
44: )
45: values
46: (
47: DECODE(px_offer_adjustment_product_id , FND_API.G_MISS_NUM , NULL, px_offer_adjustment_product_id)
48: , DECODE(p_offer_adjustment_id , FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id)
49: , DECODE(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
50: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)

Line 48: , DECODE(p_offer_adjustment_id , FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id)

44: )
45: values
46: (
47: DECODE(px_offer_adjustment_product_id , FND_API.G_MISS_NUM , NULL, px_offer_adjustment_product_id)
48: , DECODE(p_offer_adjustment_id , FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id)
49: , DECODE(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
50: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)
52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)

Line 49: , DECODE(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)

45: values
46: (
47: DECODE(px_offer_adjustment_product_id , FND_API.G_MISS_NUM , NULL, px_offer_adjustment_product_id)
48: , DECODE(p_offer_adjustment_id , FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id)
49: , DECODE(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
50: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)
52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)
53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)

Line 50: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)

46: (
47: DECODE(px_offer_adjustment_product_id , FND_API.G_MISS_NUM , NULL, px_offer_adjustment_product_id)
48: , DECODE(p_offer_adjustment_id , FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id)
49: , DECODE(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
50: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)
52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)
53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)
54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )

Line 51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)

47: DECODE(px_offer_adjustment_product_id , FND_API.G_MISS_NUM , NULL, px_offer_adjustment_product_id)
48: , DECODE(p_offer_adjustment_id , FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id)
49: , DECODE(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
50: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)
52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)
53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)
54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )
55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)

Line 52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)

48: , DECODE(p_offer_adjustment_id , FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id)
49: , DECODE(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
50: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)
52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)
53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)
54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )
55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)

Line 53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)

49: , DECODE(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
50: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)
52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)
53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)
54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )
55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)
57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)

Line 54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )

50: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)
52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)
53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)
54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )
55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)
57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)

Line 55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)

51: , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)
52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)
53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)
54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )
55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)
57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
59: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)

Line 56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)

52: , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)
53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)
54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )
55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)
57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
59: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)
60: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)

Line 57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)

53: , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)
54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )
55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)
57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
59: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)
60: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
61: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)

Line 58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)

54: , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )
55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)
57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
59: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)
60: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
61: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
62: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)

Line 59: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)

55: , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)
57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
59: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)
60: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
61: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
62: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
63:

Line 60: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)

56: , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)
57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
59: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)
60: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
61: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
62: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
63:
64: );

Line 61: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)

57: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
59: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)
60: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
61: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
62: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
63:
64: );
65: END INSERT_ROW;

Line 62: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)

58: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
59: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)
60: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
61: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
62: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
63:
64: );
65: END INSERT_ROW;
66:

Line 88: offer_adjustment_product_id = DECODE(p_offer_adjustment_product_id, null, offer_adjustment_product_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_product_id)

84: BEGIN
85:
86: UPDATE OZF_OFFER_ADJUSTMENT_PRODUCTS
87: SET
88: offer_adjustment_product_id = DECODE(p_offer_adjustment_product_id, null, offer_adjustment_product_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_product_id)
89: , offer_adjustment_id = DECODE(P_offer_adjustment_id , null, offer_adjustment_id , FND_API.G_MISS_NUM,null, p_offer_adjustment_id)
90: , offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID, NULL, OFFER_DISCOUNT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
91: , off_discount_product_id = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)

Line 89: , offer_adjustment_id = DECODE(P_offer_adjustment_id , null, offer_adjustment_id , FND_API.G_MISS_NUM,null, p_offer_adjustment_id)

85:
86: UPDATE OZF_OFFER_ADJUSTMENT_PRODUCTS
87: SET
88: offer_adjustment_product_id = DECODE(p_offer_adjustment_product_id, null, offer_adjustment_product_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_product_id)
89: , offer_adjustment_id = DECODE(P_offer_adjustment_id , null, offer_adjustment_id , FND_API.G_MISS_NUM,null, p_offer_adjustment_id)
90: , offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID, NULL, OFFER_DISCOUNT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
91: , off_discount_product_id = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)
93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)

Line 90: , offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID, NULL, OFFER_DISCOUNT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)

86: UPDATE OZF_OFFER_ADJUSTMENT_PRODUCTS
87: SET
88: offer_adjustment_product_id = DECODE(p_offer_adjustment_product_id, null, offer_adjustment_product_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_product_id)
89: , offer_adjustment_id = DECODE(P_offer_adjustment_id , null, offer_adjustment_id , FND_API.G_MISS_NUM,null, p_offer_adjustment_id)
90: , offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID, NULL, OFFER_DISCOUNT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
91: , off_discount_product_id = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)
93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)
94: , product_attr_value = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)

Line 91: , off_discount_product_id = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)

87: SET
88: offer_adjustment_product_id = DECODE(p_offer_adjustment_product_id, null, offer_adjustment_product_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_product_id)
89: , offer_adjustment_id = DECODE(P_offer_adjustment_id , null, offer_adjustment_id , FND_API.G_MISS_NUM,null, p_offer_adjustment_id)
90: , offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID, NULL, OFFER_DISCOUNT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
91: , off_discount_product_id = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)
93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)
94: , product_attr_value = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)
95: , excluder_flag = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)

Line 92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)

88: offer_adjustment_product_id = DECODE(p_offer_adjustment_product_id, null, offer_adjustment_product_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_product_id)
89: , offer_adjustment_id = DECODE(P_offer_adjustment_id , null, offer_adjustment_id , FND_API.G_MISS_NUM,null, p_offer_adjustment_id)
90: , offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID, NULL, OFFER_DISCOUNT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
91: , off_discount_product_id = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)
93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)
94: , product_attr_value = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)
95: , excluder_flag = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)
96: , apply_discount_flag = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)

Line 93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)

89: , offer_adjustment_id = DECODE(P_offer_adjustment_id , null, offer_adjustment_id , FND_API.G_MISS_NUM,null, p_offer_adjustment_id)
90: , offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID, NULL, OFFER_DISCOUNT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
91: , off_discount_product_id = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)
93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)
94: , product_attr_value = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)
95: , excluder_flag = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)
96: , apply_discount_flag = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
97: , include_volume_flag = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)

Line 94: , product_attr_value = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)

90: , offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID, NULL, OFFER_DISCOUNT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
91: , off_discount_product_id = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)
93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)
94: , product_attr_value = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)
95: , excluder_flag = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)
96: , apply_discount_flag = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
97: , include_volume_flag = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)
98: , object_version_number = NVL(p_object_version_number , 0)+1

Line 95: , excluder_flag = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)

91: , off_discount_product_id = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)
93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)
94: , product_attr_value = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)
95: , excluder_flag = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)
96: , apply_discount_flag = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
97: , include_volume_flag = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)
98: , object_version_number = NVL(p_object_version_number , 0)+1
99: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date )

Line 96: , apply_discount_flag = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)

92: , product_context = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)
93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)
94: , product_attr_value = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)
95: , excluder_flag = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)
96: , apply_discount_flag = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
97: , include_volume_flag = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)
98: , object_version_number = NVL(p_object_version_number , 0)+1
99: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date )
100: , last_update_login = DECODE(P_LAST_UPDATE_LOGIN, null, last_update_login, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_update_login)

Line 97: , include_volume_flag = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)

93: , product_attribute = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)
94: , product_attr_value = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)
95: , excluder_flag = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)
96: , apply_discount_flag = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
97: , include_volume_flag = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)
98: , object_version_number = NVL(p_object_version_number , 0)+1
99: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date )
100: , last_update_login = DECODE(P_LAST_UPDATE_LOGIN, null, last_update_login, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_update_login)
101: , last_updated_by = DECODE(P_LAST_UPDATED_BY, null, last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)

Line 99: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date )

95: , excluder_flag = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)
96: , apply_discount_flag = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
97: , include_volume_flag = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)
98: , object_version_number = NVL(p_object_version_number , 0)+1
99: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date )
100: , last_update_login = DECODE(P_LAST_UPDATE_LOGIN, null, last_update_login, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_update_login)
101: , last_updated_by = DECODE(P_LAST_UPDATED_BY, null, last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
102: WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
103: AND object_version_number = p_object_version_number;

Line 100: , last_update_login = DECODE(P_LAST_UPDATE_LOGIN, null, last_update_login, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_update_login)

96: , apply_discount_flag = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
97: , include_volume_flag = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)
98: , object_version_number = NVL(p_object_version_number , 0)+1
99: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date )
100: , last_update_login = DECODE(P_LAST_UPDATE_LOGIN, null, last_update_login, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_update_login)
101: , last_updated_by = DECODE(P_LAST_UPDATED_BY, null, last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
102: WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
103: AND object_version_number = p_object_version_number;
104:

Line 101: , last_updated_by = DECODE(P_LAST_UPDATED_BY, null, last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)

97: , include_volume_flag = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)
98: , object_version_number = NVL(p_object_version_number , 0)+1
99: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date )
100: , last_update_login = DECODE(P_LAST_UPDATE_LOGIN, null, last_update_login, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_update_login)
101: , last_updated_by = DECODE(P_LAST_UPDATED_BY, null, last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
102: WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
103: AND object_version_number = p_object_version_number;
104:
105: IF SQL%NOTFOUND THEN

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
103: AND object_version_number = p_object_version_number;
104:
105: IF SQL%NOTFOUND THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: END UPDATE_ROW;
110:

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
120: AND object_version_number = p_object_version_number;
121:
122: IF sql%notfound THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125: END delete_row;
126:
127:

Line 147: RAISE FND_API.g_exc_error;

143: FETCH c INTO recinfo;
144: IF (c%NOTFOUND) THEN
145: CLOSE c;
146: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
147: RAISE FND_API.g_exc_error;
148: END IF;
149: CLOSE c;
150:
151: END LOCK_ROW;