DBA Data[Home] [Help]

APPS.CSD_REPAIR_TYPES_PKG dependencies on FND_API

Line 292: X_RES_DT_CALC_POINT IN VARCHAR2 := fnd_api.g_miss_char

288: X_INTERNAL_ORDER_FLAG in Varchar2,
289: X_THIRD_PARTY_FLAG in Varchar2,
290: X_OBJECT_VERSION_NUMBER in Number,
291: X_START_FLOW_STATUS_ID in Number,
292: X_RES_DT_CALC_POINT IN VARCHAR2 := fnd_api.g_miss_char
293: ) is
294: begin
295: update CSD_REPAIR_TYPES_B set
296: WORKFLOW_ITEM_TYPE = X_WORKFLOW_ITEM_TYPE,

Line 332: THIRD_SHIP_TXN_BILLING_TYPE_ID = decode( X_THIRD_SHIP_TXN_B_TYPE_ID, FND_API.G_MISS_NUM, THIRD_SHIP_TXN_BILLING_TYPE_ID, X_THIRD_SHIP_TXN_B_TYPE_ID),

328: CPR_TXN_BILLING_TYPE_ID = X_CPR_TXN_BILLING_TYPE_ID,
329: CPS_TXN_BILLING_TYPE_ID = X_CPS_TXN_BILLING_TYPE_ID,
330: LR_TXN_BILLING_TYPE_ID = X_LR_TXN_BILLING_TYPE_ID,
331: LS_TXN_BILLING_TYPE_ID = X_LS_TXN_BILLING_TYPE_ID,
332: THIRD_SHIP_TXN_BILLING_TYPE_ID = decode( X_THIRD_SHIP_TXN_B_TYPE_ID, FND_API.G_MISS_NUM, THIRD_SHIP_TXN_BILLING_TYPE_ID, X_THIRD_SHIP_TXN_B_TYPE_ID),
333: THIRD_RMA_TXN_BILLING_TYPE_ID = decode( X_THIRD_RMA_TXN_B_TYPE_ID, FND_API.G_MISS_NUM, THIRD_RMA_TXN_BILLING_TYPE_ID, X_THIRD_RMA_TXN_B_TYPE_ID),
334: MTL_TXN_BILLING_TYPE_ID = X_MTL_TXN_BILLING_TYPE_ID,
335: LBR_TXN_BILLING_TYPE_ID = X_LBR_TXN_BILLING_TYPE_ID,
336: EXP_TXN_BILLING_TYPE_ID = X_EXP_TXN_BILLING_TYPE_ID,

Line 333: THIRD_RMA_TXN_BILLING_TYPE_ID = decode( X_THIRD_RMA_TXN_B_TYPE_ID, FND_API.G_MISS_NUM, THIRD_RMA_TXN_BILLING_TYPE_ID, X_THIRD_RMA_TXN_B_TYPE_ID),

329: CPS_TXN_BILLING_TYPE_ID = X_CPS_TXN_BILLING_TYPE_ID,
330: LR_TXN_BILLING_TYPE_ID = X_LR_TXN_BILLING_TYPE_ID,
331: LS_TXN_BILLING_TYPE_ID = X_LS_TXN_BILLING_TYPE_ID,
332: THIRD_SHIP_TXN_BILLING_TYPE_ID = decode( X_THIRD_SHIP_TXN_B_TYPE_ID, FND_API.G_MISS_NUM, THIRD_SHIP_TXN_BILLING_TYPE_ID, X_THIRD_SHIP_TXN_B_TYPE_ID),
333: THIRD_RMA_TXN_BILLING_TYPE_ID = decode( X_THIRD_RMA_TXN_B_TYPE_ID, FND_API.G_MISS_NUM, THIRD_RMA_TXN_BILLING_TYPE_ID, X_THIRD_RMA_TXN_B_TYPE_ID),
334: MTL_TXN_BILLING_TYPE_ID = X_MTL_TXN_BILLING_TYPE_ID,
335: LBR_TXN_BILLING_TYPE_ID = X_LBR_TXN_BILLING_TYPE_ID,
336: EXP_TXN_BILLING_TYPE_ID = X_EXP_TXN_BILLING_TYPE_ID,
337: INTERNAL_ORDER_FLAG = X_INTERNAL_ORDER_FLAG,

Line 338: THIRD_PARTY_FLAG = decode( X_THIRD_PARTY_FLAG, FND_API.G_MISS_CHAR, THIRD_PARTY_FLAG, X_THIRD_PARTY_FLAG),

334: MTL_TXN_BILLING_TYPE_ID = X_MTL_TXN_BILLING_TYPE_ID,
335: LBR_TXN_BILLING_TYPE_ID = X_LBR_TXN_BILLING_TYPE_ID,
336: EXP_TXN_BILLING_TYPE_ID = X_EXP_TXN_BILLING_TYPE_ID,
337: INTERNAL_ORDER_FLAG = X_INTERNAL_ORDER_FLAG,
338: THIRD_PARTY_FLAG = decode( X_THIRD_PARTY_FLAG, FND_API.G_MISS_CHAR, THIRD_PARTY_FLAG, X_THIRD_PARTY_FLAG),
339: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
340: START_FLOW_STATUS_ID = X_START_FLOW_STATUS_ID,
341: RES_DT_CALC_POINT = decode(X_RES_DT_CALC_POINT, FND_API.G_MISS_CHAR, RES_DT_CALC_POINT, X_RES_DT_CALC_POINT)
342: where REPAIR_TYPE_ID = X_REPAIR_TYPE_ID;

Line 341: RES_DT_CALC_POINT = decode(X_RES_DT_CALC_POINT, FND_API.G_MISS_CHAR, RES_DT_CALC_POINT, X_RES_DT_CALC_POINT)

337: INTERNAL_ORDER_FLAG = X_INTERNAL_ORDER_FLAG,
338: THIRD_PARTY_FLAG = decode( X_THIRD_PARTY_FLAG, FND_API.G_MISS_CHAR, THIRD_PARTY_FLAG, X_THIRD_PARTY_FLAG),
339: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
340: START_FLOW_STATUS_ID = X_START_FLOW_STATUS_ID,
341: RES_DT_CALC_POINT = decode(X_RES_DT_CALC_POINT, FND_API.G_MISS_CHAR, RES_DT_CALC_POINT, X_RES_DT_CALC_POINT)
342: where REPAIR_TYPE_ID = X_REPAIR_TYPE_ID;
343:
344: if (sql%notfound) then
345: raise no_data_found;