APPS.CSI_TXN_TYPES_PKG dependencies on FND_API

Line 37: If (px_TRANSACTION_TYPE_ID IS NULL) OR (px_TRANSACTION_TYPE_ID = FND_API.G_MISS_NUM) then

33:
34: IS
35: CURSOR C2 IS SELECT CSI_TXN_TYPES_S.nextval FROM sys.dual;
36: BEGIN
37: If (px_TRANSACTION_TYPE_ID IS NULL) OR (px_TRANSACTION_TYPE_ID = FND_API.G_MISS_NUM) then
38: OPEN C2;
39: FETCH C2 INTO px_TRANSACTION_TYPE_ID;
40: CLOSE C2;
41: End If;

Line 59: decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_APPLICATION_ID),

55: OBJECT_VERSION_NUMBER,
56: SEEDED_FLAG
57: ) VALUES (
58: px_TRANSACTION_TYPE_ID,
59: decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_APPLICATION_ID),
60: decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_TYPE),
61: decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TXN_TYPE_NAME),
62: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),

Line 60: decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_TYPE),

56: SEEDED_FLAG
57: ) VALUES (
58: px_TRANSACTION_TYPE_ID,
59: decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_APPLICATION_ID),
60: decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_TYPE),
61: decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TXN_TYPE_NAME),
62: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),
64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),

Line 61: decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TXN_TYPE_NAME),

57: ) VALUES (
58: px_TRANSACTION_TYPE_ID,
59: decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_APPLICATION_ID),
60: decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_TYPE),
61: decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TXN_TYPE_NAME),
62: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),
64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),
65: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

Line 62: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),

58: px_TRANSACTION_TYPE_ID,
59: decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_APPLICATION_ID),
60: decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_TYPE),
61: decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TXN_TYPE_NAME),
62: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),
64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),
65: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
66: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

Line 63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),

59: decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_APPLICATION_ID),
60: decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_TYPE),
61: decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TXN_TYPE_NAME),
62: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),
64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),
65: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
66: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
67: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),

60: decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_TYPE),
61: decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TXN_TYPE_NAME),
62: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),
64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),
65: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
66: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
67: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
68: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

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

61: decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TXN_TYPE_NAME),
62: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),
64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),
65: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
66: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
67: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
68: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
69: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

62: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),
64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),
65: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
66: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
67: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
68: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
69: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
70: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),

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

63: decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_OBJECT_CODE),
64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),
65: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
66: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
67: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
68: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
69: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
70: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
71: 'N'

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

64: decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IN_OUT_FLAG),
65: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
66: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
67: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
68: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
69: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
70: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
71: 'N'
72: );

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

65: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
66: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
67: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
68: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
69: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
70: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
71: 'N'
72: );
73:

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

66: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
67: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
68: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
69: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
70: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
71: 'N'
72: );
73:
74: INSERT INTO CSI_SOURCE_IB_TYPES(

Line 88: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),

84: SEEDED_FLAG,
85: OBJECT_VERSION_NUMBER
86: ) VALUES (
87: px_TRANSACTION_TYPE_ID,
88: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
89: decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FLAG),
90: decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_IB_FLAG),
91: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

Line 89: decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FLAG),

85: OBJECT_VERSION_NUMBER
86: ) VALUES (
87: px_TRANSACTION_TYPE_ID,
88: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
89: decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FLAG),
90: decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_IB_FLAG),
91: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
93: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 90: decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_IB_FLAG),

86: ) VALUES (
87: px_TRANSACTION_TYPE_ID,
88: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
89: decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FLAG),
90: decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_IB_FLAG),
91: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
93: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
94: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

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

87: px_TRANSACTION_TYPE_ID,
88: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
89: decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FLAG),
90: decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_IB_FLAG),
91: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
93: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
94: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
95: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

88: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
89: decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FLAG),
90: decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_IB_FLAG),
91: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
93: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
94: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
95: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
96: 'N',

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

89: decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FLAG),
90: decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_IB_FLAG),
91: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
93: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
94: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
95: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
96: 'N',
97: 1 );

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

90: decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_IB_FLAG),
91: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
93: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
94: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
95: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
96: 'N',
97: 1 );
98:

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

91: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
93: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
94: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
95: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
96: 'N',
97: 1 );
98:
99:

Line 125: SOURCE_APPLICATION_ID = decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, SOURCE_APPLICATION_ID, p_SOURCE_APPLICATION_ID),

121: IS
122: BEGIN
123: Update CSI_TXN_TYPES
124: SET
125: SOURCE_APPLICATION_ID = decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, SOURCE_APPLICATION_ID, p_SOURCE_APPLICATION_ID),
126: SOURCE_TRANSACTION_TYPE = decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TYPE, p_SOURCE_TRANSACTION_TYPE),
127: SOURCE_TXN_TYPE_NAME = decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, SOURCE_TXN_TYPE_NAME, p_SOURCE_TXN_TYPE_NAME),
128: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),

Line 126: SOURCE_TRANSACTION_TYPE = decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TYPE, p_SOURCE_TRANSACTION_TYPE),

122: BEGIN
123: Update CSI_TXN_TYPES
124: SET
125: SOURCE_APPLICATION_ID = decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, SOURCE_APPLICATION_ID, p_SOURCE_APPLICATION_ID),
126: SOURCE_TRANSACTION_TYPE = decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TYPE, p_SOURCE_TRANSACTION_TYPE),
127: SOURCE_TXN_TYPE_NAME = decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, SOURCE_TXN_TYPE_NAME, p_SOURCE_TXN_TYPE_NAME),
128: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),
130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),

Line 127: SOURCE_TXN_TYPE_NAME = decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, SOURCE_TXN_TYPE_NAME, p_SOURCE_TXN_TYPE_NAME),

123: Update CSI_TXN_TYPES
124: SET
125: SOURCE_APPLICATION_ID = decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, SOURCE_APPLICATION_ID, p_SOURCE_APPLICATION_ID),
126: SOURCE_TRANSACTION_TYPE = decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TYPE, p_SOURCE_TRANSACTION_TYPE),
127: SOURCE_TXN_TYPE_NAME = decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, SOURCE_TXN_TYPE_NAME, p_SOURCE_TXN_TYPE_NAME),
128: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),
130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),
131: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 128: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),

124: SET
125: SOURCE_APPLICATION_ID = decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, SOURCE_APPLICATION_ID, p_SOURCE_APPLICATION_ID),
126: SOURCE_TRANSACTION_TYPE = decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TYPE, p_SOURCE_TRANSACTION_TYPE),
127: SOURCE_TXN_TYPE_NAME = decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, SOURCE_TXN_TYPE_NAME, p_SOURCE_TXN_TYPE_NAME),
128: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),
130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),
131: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
132: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),

125: SOURCE_APPLICATION_ID = decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, SOURCE_APPLICATION_ID, p_SOURCE_APPLICATION_ID),
126: SOURCE_TRANSACTION_TYPE = decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TYPE, p_SOURCE_TRANSACTION_TYPE),
127: SOURCE_TXN_TYPE_NAME = decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, SOURCE_TXN_TYPE_NAME, p_SOURCE_TXN_TYPE_NAME),
128: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),
130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),
131: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
132: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
133: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),

126: SOURCE_TRANSACTION_TYPE = decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TYPE, p_SOURCE_TRANSACTION_TYPE),
127: SOURCE_TXN_TYPE_NAME = decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, SOURCE_TXN_TYPE_NAME, p_SOURCE_TXN_TYPE_NAME),
128: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),
130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),
131: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
132: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
133: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
134: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

127: SOURCE_TXN_TYPE_NAME = decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, SOURCE_TXN_TYPE_NAME, p_SOURCE_TXN_TYPE_NAME),
128: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),
130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),
131: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
132: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
133: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
134: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
135: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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

128: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),
130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),
131: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
132: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
133: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
134: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
135: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
136: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

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

129: SOURCE_OBJECT_CODE = decode( p_SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR, SOURCE_OBJECT_CODE, p_SOURCE_OBJECT_CODE),
130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),
131: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
132: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
133: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
134: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
135: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
136: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
137: --OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

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

130: IN_OUT_FLAG = decode( p_IN_OUT_FLAG, FND_API.G_MISS_CHAR, IN_OUT_FLAG, p_IN_OUT_FLAG),
131: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
132: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
133: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
134: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
135: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
136: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
137: --OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
138: where TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID;

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

131: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
132: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
133: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
134: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
135: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
136: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
137: --OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
138: where TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID;
139:

Line 137: --OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

133: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
134: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
135: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
136: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
137: --OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
138: where TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID;
139:
140: Update CSI_SOURCE_IB_TYPES
141: SET

Line 142: DEFAULT_FLAG = decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, DEFAULT_FLAG, p_DEFAULT_FLAG),

138: where TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID;
139:
140: Update CSI_SOURCE_IB_TYPES
141: SET
142: DEFAULT_FLAG = decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, DEFAULT_FLAG, p_DEFAULT_FLAG),
143: UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG),
144: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
145: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
146: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 143: UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG),

139:
140: Update CSI_SOURCE_IB_TYPES
141: SET
142: DEFAULT_FLAG = decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, DEFAULT_FLAG, p_DEFAULT_FLAG),
143: UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG),
144: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
145: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
146: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
147: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

140: Update CSI_SOURCE_IB_TYPES
141: SET
142: DEFAULT_FLAG = decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, DEFAULT_FLAG, p_DEFAULT_FLAG),
143: UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG),
144: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
145: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
146: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
147: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
148: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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

141: SET
142: DEFAULT_FLAG = decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, DEFAULT_FLAG, p_DEFAULT_FLAG),
143: UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG),
144: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
145: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
146: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
147: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
148: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
149: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

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

142: DEFAULT_FLAG = decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, DEFAULT_FLAG, p_DEFAULT_FLAG),
143: UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG),
144: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
145: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
146: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
147: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
148: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
149: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
150: where TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID

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

143: UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG),
144: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
145: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
146: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
147: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
148: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
149: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
150: where TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID
151: and SUB_TYPE_ID = p_sub_type_id;

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

144: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
145: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
146: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
147: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
148: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
149: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
150: where TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID
151: and SUB_TYPE_ID = p_sub_type_id;
152: