DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on DUAL

Line 2039: SELECT FUN_DIST_LINES_S.nextval INTO l_dist_id FROM dual;

2035: LOOP
2036:
2037:
2038:
2039: SELECT FUN_DIST_LINES_S.nextval INTO l_dist_id FROM dual;
2040:
2041: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.recipient_interco_acct', 'Inserting distribution ' || l_dist_id);
2043: END IF;

Line 3016: FROM dual;

3012: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Build the initiator distribution lines');
3013: END IF;
3014: SELECT FUN_DIST_LINES_S.nextval
3015: INTO l_new_dist_tbl(l_new_index).dist_id
3016: FROM dual;
3017:
3018: l_new_dist_tbl(l_new_index).line_id := l_init_dist_tbl(1).line_id;
3019: l_new_dist_tbl(l_new_index).trx_id := l_init_dist_tbl(1).trx_id;
3020: l_new_dist_tbl(l_new_index).dist_number := l_new_dist_tbl(l_new_index).dist_id;

Line 3388: FROM dual;

3384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Build the Distribution lines');
3385: END IF;
3386: SELECT FUN_DIST_LINES_S.nextval
3387: INTO l_new_dist_tbl(l_new_index).dist_id
3388: FROM dual;
3389:
3390: l_new_dist_tbl(l_new_index).line_id := l_reci_dist_tbl(1).line_id;
3391: l_new_dist_tbl(l_new_index).trx_id := l_reci_dist_tbl(1).trx_id;
3392: l_new_dist_tbl(l_new_index).dist_number := l_new_dist_tbl(l_new_index).dist_id;