DBA Data[Home] [Help]

APPS.ARP_UPGRADE_COMMON_UTIL dependencies on AR_DISTRIBUTIONS_ALL

Line 21: | Inserts a record into AR_DISTRIBUTIONS_ALL table, inserts org_id |

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: | |

Line 44: PROCEDURE insert_p( p_dist_rec IN ar_distributions_all%ROWTYPE,

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:

Line 45: p_line_id OUT NOCOPY ar_distributions_all.line_id%TYPE ) IS

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

Line 47: l_line_id ar_distributions_all.line_id%TYPE;

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

Line 56: INSERT INTO ar_distributions_all (

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,