DBA Data[Home] [Help]

APPS.IEX_PROMISES_BATCH_PUB dependencies on FND_API

Line 52: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

48: P_ORG_ID IN NUMBER DEFAULT NULL); --Added for MOAC
49:
50: PROCEDURE CLOSE_PROMISES(
51: P_API_VERSION IN NUMBER,
52: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 53: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

49:
50: PROCEDURE CLOSE_PROMISES(
51: P_API_VERSION IN NUMBER,
52: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56: X_MSG_COUNT OUT NOCOPY NUMBER,
57: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 54: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

50: PROCEDURE CLOSE_PROMISES(
51: P_API_VERSION IN NUMBER,
52: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56: X_MSG_COUNT OUT NOCOPY NUMBER,
57: X_MSG_DATA OUT NOCOPY VARCHAR2,
58: p_payments_tbl IN IEX_PAYMENTS_BATCH_PUB.CL_INV_TBL_TYPE);

Line 62: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

58: p_payments_tbl IN IEX_PAYMENTS_BATCH_PUB.CL_INV_TBL_TYPE);
59:
60: PROCEDURE CLOSE_PROMISES(
61: P_API_VERSION IN NUMBER,
62: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
65: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 63: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

59:
60: PROCEDURE CLOSE_PROMISES(
61: P_API_VERSION IN NUMBER,
62: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
65: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66: X_MSG_COUNT OUT NOCOPY NUMBER,
67: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 64: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

60: PROCEDURE CLOSE_PROMISES(
61: P_API_VERSION IN NUMBER,
62: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
65: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66: X_MSG_COUNT OUT NOCOPY NUMBER,
67: X_MSG_DATA OUT NOCOPY VARCHAR2,
68: P_DELINQ_TBL IN IEX_UTILITIES.t_del_id);

Line 72: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

68: P_DELINQ_TBL IN IEX_UTILITIES.t_del_id);
69:
70: PROCEDURE PROCESS_ALL_PROMISES(
71: P_API_VERSION IN NUMBER,
72: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 73: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

69:
70: PROCEDURE PROCESS_ALL_PROMISES(
71: P_API_VERSION IN NUMBER,
72: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76: X_MSG_COUNT OUT NOCOPY NUMBER,
77: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 74: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

70: PROCEDURE PROCESS_ALL_PROMISES(
71: P_API_VERSION IN NUMBER,
72: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
74: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
75: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76: X_MSG_COUNT OUT NOCOPY NUMBER,
77: X_MSG_DATA OUT NOCOPY VARCHAR2);
78:

Line 81: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

77: X_MSG_DATA OUT NOCOPY VARCHAR2);
78:
79: PROCEDURE PROCESS_REVERSALS(
80: P_API_VERSION IN NUMBER,
81: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 82: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

78:
79: PROCEDURE PROCESS_REVERSALS(
80: P_API_VERSION IN NUMBER,
81: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85: X_MSG_COUNT OUT NOCOPY NUMBER,
86: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 83: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

79: PROCEDURE PROCESS_REVERSALS(
80: P_API_VERSION IN NUMBER,
81: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85: X_MSG_COUNT OUT NOCOPY NUMBER,
86: X_MSG_DATA OUT NOCOPY VARCHAR2,
87: P_TYPE IN VARCHAR2);

Line 91: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

87: P_TYPE IN VARCHAR2);
88:
89: PROCEDURE PROCESS_PROMISES(
90: P_API_VERSION IN NUMBER,
91: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 92: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

88:
89: PROCEDURE PROCESS_PROMISES(
90: P_API_VERSION IN NUMBER,
91: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95: X_MSG_COUNT OUT NOCOPY NUMBER,
96: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 93: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

89: PROCEDURE PROCESS_PROMISES(
90: P_API_VERSION IN NUMBER,
91: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95: X_MSG_COUNT OUT NOCOPY NUMBER,
96: X_MSG_DATA OUT NOCOPY VARCHAR2,
97: P_TYPE IN VARCHAR2);

Line 101: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

97: P_TYPE IN VARCHAR2);
98:
99: PROCEDURE APPLY_PROMISES_FIFO(
100: P_API_VERSION IN NUMBER,
101: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
102: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
103: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
104: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 102: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

98:
99: PROCEDURE APPLY_PROMISES_FIFO(
100: P_API_VERSION IN NUMBER,
101: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
102: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
103: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
104: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105: X_MSG_COUNT OUT NOCOPY NUMBER,
106: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 103: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

99: PROCEDURE APPLY_PROMISES_FIFO(
100: P_API_VERSION IN NUMBER,
101: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
102: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
103: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
104: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105: X_MSG_COUNT OUT NOCOPY NUMBER,
106: X_MSG_DATA OUT NOCOPY VARCHAR2,
107: P_PROMISES_TBL IN OUT NOCOPY IEX_PROMISES_BATCH_PUB.PROMISES_TBL,

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

108: P_TYPE IN VARCHAR2);
109:
110: PROCEDURE PROCESS_PROMISE_CALLBACKS(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,

Line 113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

109:
110: PROCEDURE PROCESS_PROMISE_CALLBACKS(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2);

Line 114: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

110: PROCEDURE PROCESS_PROMISE_CALLBACKS(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2);
118:

Line 121: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

117: x_msg_data OUT NOCOPY VARCHAR2);
118:
119: PROCEDURE REOPEN_PROMISES(
120: P_API_VERSION IN NUMBER,
121: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
124: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
125: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 122: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

118:
119: PROCEDURE REOPEN_PROMISES(
120: P_API_VERSION IN NUMBER,
121: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
124: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
125: X_MSG_COUNT OUT NOCOPY NUMBER,
126: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 123: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

119: PROCEDURE REOPEN_PROMISES(
120: P_API_VERSION IN NUMBER,
121: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
124: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
125: X_MSG_COUNT OUT NOCOPY NUMBER,
126: X_MSG_DATA OUT NOCOPY VARCHAR2,
127: p_dels_tbl IN DBMS_SQL.NUMBER_TABLE /*table of delinquency ids*/);