17: | PROCEDURE |
18: | insert_p |
19: | |
20: | DESCRIPTION |
21: | Inserts a record into AR_DISTRIBUTIONS_ALL table, inserts org_id |
22: | column for Multi Org. |
23: | |
24: | SCOPE - PUBLIC |
25: | |
40: | |
41: | 07-DEC-98 VAHLUWAL Created for Release 11.5 upgrade |
42: | |
43: +===========================================================================*/
44: PROCEDURE insert_p( p_dist_rec IN ar_distributions_all%ROWTYPE,
45: p_line_id OUT NOCOPY ar_distributions_all.line_id%TYPE ) IS
46:
47: l_line_id ar_distributions_all.line_id%TYPE;
48:
41: | 07-DEC-98 VAHLUWAL Created for Release 11.5 upgrade |
42: | |
43: +===========================================================================*/
44: PROCEDURE insert_p( p_dist_rec IN ar_distributions_all%ROWTYPE,
45: p_line_id OUT NOCOPY ar_distributions_all.line_id%TYPE ) IS
46:
47: l_line_id ar_distributions_all.line_id%TYPE;
48:
49: BEGIN
43: +===========================================================================*/
44: PROCEDURE insert_p( p_dist_rec IN ar_distributions_all%ROWTYPE,
45: p_line_id OUT NOCOPY ar_distributions_all.line_id%TYPE ) IS
46:
47: l_line_id ar_distributions_all.line_id%TYPE;
48:
49: BEGIN
50: --
51: SELECT ar_distributions_s.nextval
52: INTO l_line_id
53: FROM dual;
54: --
55:
56: INSERT INTO ar_distributions_all (
57: line_id,
58: source_id,
59: source_table,
60: source_type,