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.AS_LEADS_LINES_LOG_PKG dependencies on FND_API

Line 57: decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),

53: forecast_date,
54: rolling_forecast_flag,
55: endday_log_flag) VALUES (
56: AS_LEAD_LINES_LOG_S.nextval,
57: decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
58: decode( p_lead_line_id,FND_API.G_MISS_NUM, NULL, p_lead_line_id),
59: decode( p_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
60: decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
61: decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

Line 58: decode( p_lead_line_id,FND_API.G_MISS_NUM, NULL, p_lead_line_id),

54: rolling_forecast_flag,
55: endday_log_flag) VALUES (
56: AS_LEAD_LINES_LOG_S.nextval,
57: decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
58: decode( p_lead_line_id,FND_API.G_MISS_NUM, NULL, p_lead_line_id),
59: decode( p_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
60: decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
61: decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
62: decode( p_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),

Line 59: decode( p_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),

55: endday_log_flag) VALUES (
56: AS_LEAD_LINES_LOG_S.nextval,
57: decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
58: decode( p_lead_line_id,FND_API.G_MISS_NUM, NULL, p_lead_line_id),
59: decode( p_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
60: decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
61: decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
62: decode( p_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
63: decode( p_created_by,FND_API.G_MISS_NUM, NULL, p_created_by),

Line 60: decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),

56: AS_LEAD_LINES_LOG_S.nextval,
57: decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
58: decode( p_lead_line_id,FND_API.G_MISS_NUM, NULL, p_lead_line_id),
59: decode( p_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
60: decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
61: decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
62: decode( p_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
63: decode( p_created_by,FND_API.G_MISS_NUM, NULL, p_created_by),
64: p_TRIGGER_MODE,

Line 61: decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

57: decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
58: decode( p_lead_line_id,FND_API.G_MISS_NUM, NULL, p_lead_line_id),
59: decode( p_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
60: decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
61: decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
62: decode( p_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
63: decode( p_created_by,FND_API.G_MISS_NUM, NULL, p_created_by),
64: p_TRIGGER_MODE,
65: decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),

Line 62: decode( p_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),

58: decode( p_lead_line_id,FND_API.G_MISS_NUM, NULL, p_lead_line_id),
59: decode( p_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
60: decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
61: decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
62: decode( p_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
63: decode( p_created_by,FND_API.G_MISS_NUM, NULL, p_created_by),
64: p_TRIGGER_MODE,
65: decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
66: decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),

Line 63: decode( p_created_by,FND_API.G_MISS_NUM, NULL, p_created_by),

59: decode( p_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date),
60: decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
61: decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
62: decode( p_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
63: decode( p_created_by,FND_API.G_MISS_NUM, NULL, p_created_by),
64: p_TRIGGER_MODE,
65: decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
66: decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
67: decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),

Line 65: decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),

61: decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
62: decode( p_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
63: decode( p_created_by,FND_API.G_MISS_NUM, NULL, p_created_by),
64: p_TRIGGER_MODE,
65: decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
66: decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
67: decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
68: decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),

Line 66: decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),

62: decode( p_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date),
63: decode( p_created_by,FND_API.G_MISS_NUM, NULL, p_created_by),
64: p_TRIGGER_MODE,
65: decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
66: decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
67: decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
68: decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),

Line 67: decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),

63: decode( p_created_by,FND_API.G_MISS_NUM, NULL, p_created_by),
64: p_TRIGGER_MODE,
65: decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
66: decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
67: decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
68: decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),

Line 68: decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),

64: p_TRIGGER_MODE,
65: decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
66: decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
67: decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
68: decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),
72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),

Line 69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),

65: decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
66: decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
67: decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
68: decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),
72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),

Line 70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),

66: decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
67: decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
68: decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),
72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
74: decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),

Line 71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),

67: decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
68: decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),
72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
74: decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
75: decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),

Line 72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),

68: decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),
72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
74: decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
75: decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
76: decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),

Line 73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),

69: decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),
72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
74: decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
75: decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
76: decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
77: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

Line 74: decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),

70: decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),
72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
74: decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
75: decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
76: decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
77: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
78:

Line 75: decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),

71: decode( p_organization,FND_API.G_MISS_NUM, NULL, p_organization),
72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
74: decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
75: decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
76: decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
77: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
78:
79: EXCEPTION

Line 76: decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),

72: decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
74: decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
75: decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
76: decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
77: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
78:
79: EXCEPTION
80: WHEN OTHERS THEN

Line 77: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

73: decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
74: decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
75: decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
76: decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
77: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
78:
79: EXCEPTION
80: WHEN OTHERS THEN
81: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG After Insert Statement Seems some error');

Line 125: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),

121: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
122: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG before Update_Row');
123: END IF;
124: Update AS_LEAD_LINES_LOG
125: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
126: last_update_date = decode( new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), new_last_update_date),
127: last_updated_by = decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
128: last_update_login = decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
129: LOG_MODE = p_TRIGGER_MODE,

Line 126: last_update_date = decode( new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), new_last_update_date),

122: 'asxtlnlb: In AS_LEADS_LINES_LOG_PKG before Update_Row');
123: END IF;
124: Update AS_LEAD_LINES_LOG
125: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
126: last_update_date = decode( new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), new_last_update_date),
127: last_updated_by = decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
128: last_update_login = decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
129: LOG_MODE = p_TRIGGER_MODE,
130: interest_type_id = decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),

Line 127: last_updated_by = decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),

123: END IF;
124: Update AS_LEAD_LINES_LOG
125: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
126: last_update_date = decode( new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), new_last_update_date),
127: last_updated_by = decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
128: last_update_login = decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
129: LOG_MODE = p_TRIGGER_MODE,
130: interest_type_id = decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
131: primary_interest_code_id = decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),

Line 128: last_update_login = decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

124: Update AS_LEAD_LINES_LOG
125: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_lead_id, FND_API.G_MISS_NUM, NULL, p_lead_id),
126: last_update_date = decode( new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), new_last_update_date),
127: last_updated_by = decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
128: last_update_login = decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
129: LOG_MODE = p_TRIGGER_MODE,
130: interest_type_id = decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
131: primary_interest_code_id = decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
132: secondary_interest_code_id = decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),

Line 130: interest_type_id = decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),

126: last_update_date = decode( new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), new_last_update_date),
127: last_updated_by = decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
128: last_update_login = decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
129: LOG_MODE = p_TRIGGER_MODE,
130: interest_type_id = decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
131: primary_interest_code_id = decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
132: secondary_interest_code_id = decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
133: product_category_id = decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),

Line 131: primary_interest_code_id = decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),

127: last_updated_by = decode( p_last_updated_by,FND_API.G_MISS_NUM, NULL, p_last_updated_by),
128: last_update_login = decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
129: LOG_MODE = p_TRIGGER_MODE,
130: interest_type_id = decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
131: primary_interest_code_id = decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
132: secondary_interest_code_id = decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
133: product_category_id = decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),

Line 132: secondary_interest_code_id = decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),

128: last_update_login = decode( p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
129: LOG_MODE = p_TRIGGER_MODE,
130: interest_type_id = decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
131: primary_interest_code_id = decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
132: secondary_interest_code_id = decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
133: product_category_id = decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),

Line 133: product_category_id = decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),

129: LOG_MODE = p_TRIGGER_MODE,
130: interest_type_id = decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
131: primary_interest_code_id = decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
132: secondary_interest_code_id = decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
133: product_category_id = decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),
137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),

Line 134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),

130: interest_type_id = decode( p_interest_type_id,FND_API.G_MISS_NUM, NULL, p_interest_type_id),
131: primary_interest_code_id = decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
132: secondary_interest_code_id = decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
133: product_category_id = decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),
137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),

Line 135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),

131: primary_interest_code_id = decode( p_primary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_primary_interest_code_id),
132: secondary_interest_code_id = decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
133: product_category_id = decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),
137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
139: org_id = decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),

Line 136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),

132: secondary_interest_code_id = decode( p_secondary_interest_code_id,FND_API.G_MISS_NUM, NULL, p_secondary_interest_code_id),
133: product_category_id = decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),
137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
139: org_id = decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
140: forecast_date = decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),

Line 137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),

133: product_category_id = decode( p_product_category_id,FND_API.G_MISS_NUM, NULL, p_product_category_id),
134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),
137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
139: org_id = decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
140: forecast_date = decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
141: rolling_forecast_flag = decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),

Line 138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),

134: product_cat_set_id = decode( p_product_cat_set_id,FND_API.G_MISS_NUM, NULL, p_product_cat_set_id),
135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),
137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
139: org_id = decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
140: forecast_date = decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
141: rolling_forecast_flag = decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
142: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)

Line 139: org_id = decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),

135: inventory_item_id = decode( p_inventory_item_id,FND_API.G_MISS_NUM, NULL, p_inventory_item_id),
136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),
137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
139: org_id = decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
140: forecast_date = decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
141: rolling_forecast_flag = decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
142: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
143: WHERE LOG_ID = (SELECT max(log_id)

Line 140: forecast_date = decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),

136: organization_id = decode( p_organization_id,FND_API.G_MISS_NUM, NULL, p_organization_id),
137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
139: org_id = decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
140: forecast_date = decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
141: rolling_forecast_flag = decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
142: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
143: WHERE LOG_ID = (SELECT max(log_id)
144: from AS_LEAD_LINES_LOG

Line 141: rolling_forecast_flag = decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),

137: source_promotion_id = decode( p_source_promotion_id,FND_API.G_MISS_NUM, NULL, p_source_promotion_id),
138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
139: org_id = decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
140: forecast_date = decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
141: rolling_forecast_flag = decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
142: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
143: WHERE LOG_ID = (SELECT max(log_id)
144: from AS_LEAD_LINES_LOG
145: where lead_line_id = old_lead_line_id);

Line 142: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)

138: offer_id = decode( p_offer_id,FND_API.G_MISS_NUM, NULL, p_offer_id),
139: org_id = decode( p_org_id,FND_API.G_MISS_NUM, NULL, p_org_id),
140: forecast_date = decode( p_forecast_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_forecast_date),
141: rolling_forecast_flag = decode( p_rolling_forecast_flag,FND_API.G_MISS_CHAR, NULL, p_rolling_forecast_flag),
142: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
143: WHERE LOG_ID = (SELECT max(log_id)
144: from AS_LEAD_LINES_LOG
145: where lead_line_id = old_lead_line_id);
146:

Line 200: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),

196: log_mode,
197: endday_log_flag
198: ) VALUES (
199: AS_LEAD_LINES_LOG_S.nextval,
200: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
201: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
202: sysdate,
203: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
204: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),

Line 201: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),

197: endday_log_flag
198: ) VALUES (
199: AS_LEAD_LINES_LOG_S.nextval,
200: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
201: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
202: sysdate,
203: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
204: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
205: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),

Line 203: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),

199: AS_LEAD_LINES_LOG_S.nextval,
200: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
201: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
202: sysdate,
203: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
204: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
205: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
206: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
207: 'D',

Line 204: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),

200: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
201: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
202: sysdate,
203: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
204: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
205: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
206: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
207: 'D',
208: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

Line 205: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),

201: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
202: sysdate,
203: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
204: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
205: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
206: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
207: 'D',
208: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
209:

Line 206: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),

202: sysdate,
203: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
204: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
205: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
206: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
207: 'D',
208: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
209:
210: EXCEPTION

Line 208: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

204: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
205: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
206: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
207: 'D',
208: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
209:
210: EXCEPTION
211: WHEN OTHERS THEN
212: -- dbms_output.put_line('In AS_LEADS_LINES_LOG_PKG After Delete Statement Seems some error');