246:
247:
248:
249: /**********Message to be displayed ************************************/
250: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
251: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
252: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
253: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
254: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
247:
248:
249: /**********Message to be displayed ************************************/
250: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
251: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
252: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
253: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
254: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
255: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
248:
249: /**********Message to be displayed ************************************/
250: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
251: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
252: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
253: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
254: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
255: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
256: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
249: /**********Message to be displayed ************************************/
250: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
251: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
252: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
253: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
254: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
255: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
256: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
257: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
250: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
251: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
252: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
253: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
254: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
255: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
256: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
257: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
258: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
251: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
252: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
253: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
254: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
255: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
256: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
257: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
258: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
259:
252: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
253: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
254: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
255: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
256: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
257: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
258: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
259:
260: /*get date mask */
253: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
254: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
255: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
256: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
257: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
258: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
259:
260: /*get date mask */
261: FII_PMV_Util.get_format_mask(l_date_mask);
254: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
255: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
256: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
257: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
258: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
259:
260: /*get date mask */
261: FII_PMV_Util.get_format_mask(l_date_mask);
262:
325: fnd_user usr
326: Where a.by_whom = usr.user_id
327: &ORDER_BY_CLAUSE ';
328:
329: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
330: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
331: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
332: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
333: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
326: Where a.by_whom = usr.user_id
327: &ORDER_BY_CLAUSE ';
328:
329: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
330: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
331: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
332: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
333: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
334: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
327: &ORDER_BY_CLAUSE ';
328:
329: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
330: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
331: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
332: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
333: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
334: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
335: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
328:
329: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
330: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
331: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
332: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
333: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
334: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
335: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
336: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
329: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_ENTRY');
330: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
331: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
332: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
333: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
334: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
335: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
336: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
337: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
330: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_PLACED');
331: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
332: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
333: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
334: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
335: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
336: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
337: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
338:
331: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_HOLD_RELEASED');
332: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
333: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
334: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
335: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
336: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
337: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
338:
339: /* Binding Section */
332: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_APPLIED');
333: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
334: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
335: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
336: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
337: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
338:
339: /* Binding Section */
340: FII_PMV_Util.bind_variable(
333: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_PREPAY_UNAPPLIED');
334: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMENT');
335: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_VOID');
336: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
337: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
338:
339: /* Binding Section */
340: FII_PMV_Util.bind_variable(
341: p_sqlstmt=>sqlstmt,