APPS.CSP_FAILURE_RATES_PKG dependencies on FND_API

Line 29: If (px_FAILURE_RATE_ID IS NULL) OR (px_FAILURE_RATE_ID = FND_API.G_MISS_NUM) then

25: ,p_PLANNING_PARAMETERS_ID NUMBER)
26: IS
27: CURSOR C2 IS SELECT CSP_FAILURE_RATES_S1.nextval FROM sys.dual;
28: BEGIN
29: If (px_FAILURE_RATE_ID IS NULL) OR (px_FAILURE_RATE_ID = FND_API.G_MISS_NUM) then
30: OPEN C2;
31: FETCH C2 INTO px_FAILURE_RATE_ID;
32: CLOSE C2;
33: End If;

Line 48: ,decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_ID)

44: ,LAST_UPDATE_LOGIN
45: ,PLANNING_PARAMETERS_ID
46: ) VALUES (
47: px_FAILURE_RATE_ID
48: ,decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_ID)
49: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
50: ,decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_CALCULATED_FAILURE_RATE)
51: ,decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_MANUAL_FAILURE_RATE)
52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

Line 49: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)

45: ,PLANNING_PARAMETERS_ID
46: ) VALUES (
47: px_FAILURE_RATE_ID
48: ,decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_ID)
49: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
50: ,decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_CALCULATED_FAILURE_RATE)
51: ,decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_MANUAL_FAILURE_RATE)
52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

Line 50: ,decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_CALCULATED_FAILURE_RATE)

46: ) VALUES (
47: px_FAILURE_RATE_ID
48: ,decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_ID)
49: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
50: ,decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_CALCULATED_FAILURE_RATE)
51: ,decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_MANUAL_FAILURE_RATE)
52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
54: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

Line 51: ,decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_MANUAL_FAILURE_RATE)

47: px_FAILURE_RATE_ID
48: ,decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_ID)
49: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
50: ,decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_CALCULATED_FAILURE_RATE)
51: ,decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_MANUAL_FAILURE_RATE)
52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
54: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
55: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

Line 52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

48: ,decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_ID)
49: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
50: ,decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_CALCULATED_FAILURE_RATE)
51: ,decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_MANUAL_FAILURE_RATE)
52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
54: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
55: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
56: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

Line 53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

49: ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
50: ,decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_CALCULATED_FAILURE_RATE)
51: ,decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_MANUAL_FAILURE_RATE)
52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
54: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
55: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
56: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
57: ,decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, NULL, p_PLANNING_PARAMETERS_ID));

Line 54: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

50: ,decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_CALCULATED_FAILURE_RATE)
51: ,decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_MANUAL_FAILURE_RATE)
52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
54: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
55: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
56: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
57: ,decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, NULL, p_PLANNING_PARAMETERS_ID));
58: End Insert_Row;

Line 55: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

51: ,decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, NULL, p_MANUAL_FAILURE_RATE)
52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
54: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
55: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
56: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
57: ,decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, NULL, p_PLANNING_PARAMETERS_ID));
58: End Insert_Row;
59: PROCEDURE Update_Row(

Line 56: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

52: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
54: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
55: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
56: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
57: ,decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, NULL, p_PLANNING_PARAMETERS_ID));
58: End Insert_Row;
59: PROCEDURE Update_Row(
60: p_FAILURE_RATE_ID NUMBER

Line 57: ,decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, NULL, p_PLANNING_PARAMETERS_ID));

53: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
54: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
55: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
56: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
57: ,decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, NULL, p_PLANNING_PARAMETERS_ID));
58: End Insert_Row;
59: PROCEDURE Update_Row(
60: p_FAILURE_RATE_ID NUMBER
61: ,p_PRODUCT_ID NUMBER

Line 75: PRODUCT_ID = decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, PRODUCT_ID, p_PRODUCT_ID)

71: IS
72: BEGIN
73: Update CSP_FAILURE_RATES
74: SET
75: PRODUCT_ID = decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, PRODUCT_ID, p_PRODUCT_ID)
76: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
77: ,CALCULATED_FAILURE_RATE = decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, CALCULATED_FAILURE_RATE, p_CALCULATED_FAILURE_RATE)
78: ,MANUAL_FAILURE_RATE = decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, MANUAL_FAILURE_RATE, p_MANUAL_FAILURE_RATE)
79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

Line 76: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)

72: BEGIN
73: Update CSP_FAILURE_RATES
74: SET
75: PRODUCT_ID = decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, PRODUCT_ID, p_PRODUCT_ID)
76: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
77: ,CALCULATED_FAILURE_RATE = decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, CALCULATED_FAILURE_RATE, p_CALCULATED_FAILURE_RATE)
78: ,MANUAL_FAILURE_RATE = decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, MANUAL_FAILURE_RATE, p_MANUAL_FAILURE_RATE)
79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 77: ,CALCULATED_FAILURE_RATE = decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, CALCULATED_FAILURE_RATE, p_CALCULATED_FAILURE_RATE)

73: Update CSP_FAILURE_RATES
74: SET
75: PRODUCT_ID = decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, PRODUCT_ID, p_PRODUCT_ID)
76: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
77: ,CALCULATED_FAILURE_RATE = decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, CALCULATED_FAILURE_RATE, p_CALCULATED_FAILURE_RATE)
78: ,MANUAL_FAILURE_RATE = decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, MANUAL_FAILURE_RATE, p_MANUAL_FAILURE_RATE)
79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
81: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 78: ,MANUAL_FAILURE_RATE = decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, MANUAL_FAILURE_RATE, p_MANUAL_FAILURE_RATE)

74: SET
75: PRODUCT_ID = decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, PRODUCT_ID, p_PRODUCT_ID)
76: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
77: ,CALCULATED_FAILURE_RATE = decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, CALCULATED_FAILURE_RATE, p_CALCULATED_FAILURE_RATE)
78: ,MANUAL_FAILURE_RATE = decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, MANUAL_FAILURE_RATE, p_MANUAL_FAILURE_RATE)
79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
81: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
82: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

Line 79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

75: PRODUCT_ID = decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, PRODUCT_ID, p_PRODUCT_ID)
76: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
77: ,CALCULATED_FAILURE_RATE = decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, CALCULATED_FAILURE_RATE, p_CALCULATED_FAILURE_RATE)
78: ,MANUAL_FAILURE_RATE = decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, MANUAL_FAILURE_RATE, p_MANUAL_FAILURE_RATE)
79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
81: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
82: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
83: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

Line 80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

76: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
77: ,CALCULATED_FAILURE_RATE = decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, CALCULATED_FAILURE_RATE, p_CALCULATED_FAILURE_RATE)
78: ,MANUAL_FAILURE_RATE = decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, MANUAL_FAILURE_RATE, p_MANUAL_FAILURE_RATE)
79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
81: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
82: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
83: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
84: ,PLANNING_PARAMETERS_ID = decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, PLANNING_PARAMETERS_ID, p_PLANNING_PARAMETERS_ID)

Line 81: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

77: ,CALCULATED_FAILURE_RATE = decode( p_CALCULATED_FAILURE_RATE, FND_API.G_MISS_NUM, CALCULATED_FAILURE_RATE, p_CALCULATED_FAILURE_RATE)
78: ,MANUAL_FAILURE_RATE = decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, MANUAL_FAILURE_RATE, p_MANUAL_FAILURE_RATE)
79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
81: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
82: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
83: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
84: ,PLANNING_PARAMETERS_ID = decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, PLANNING_PARAMETERS_ID, p_PLANNING_PARAMETERS_ID)
85: where FAILURE_RATE_ID = p_FAILURE_RATE_ID;

Line 82: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

78: ,MANUAL_FAILURE_RATE = decode( p_MANUAL_FAILURE_RATE, FND_API.G_MISS_NUM, MANUAL_FAILURE_RATE, p_MANUAL_FAILURE_RATE)
79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
81: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
82: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
83: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
84: ,PLANNING_PARAMETERS_ID = decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, PLANNING_PARAMETERS_ID, p_PLANNING_PARAMETERS_ID)
85: where FAILURE_RATE_ID = p_FAILURE_RATE_ID;
86: If (SQL%NOTFOUND) then

Line 83: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

79: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
81: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
82: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
83: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
84: ,PLANNING_PARAMETERS_ID = decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, PLANNING_PARAMETERS_ID, p_PLANNING_PARAMETERS_ID)
85: where FAILURE_RATE_ID = p_FAILURE_RATE_ID;
86: If (SQL%NOTFOUND) then
87: RAISE NO_DATA_FOUND;

Line 84: ,PLANNING_PARAMETERS_ID = decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, PLANNING_PARAMETERS_ID, p_PLANNING_PARAMETERS_ID)

80: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
81: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
82: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
83: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
84: ,PLANNING_PARAMETERS_ID = decode( p_PLANNING_PARAMETERS_ID, FND_API.G_MISS_NUM, PLANNING_PARAMETERS_ID, p_PLANNING_PARAMETERS_ID)
85: where FAILURE_RATE_ID = p_FAILURE_RATE_ID;
86: If (SQL%NOTFOUND) then
87: RAISE NO_DATA_FOUND;
88: End If;