12: * @rep:category BUSINESS_ENTITY IGC_CONTRACT_COMMITMENT
13: */
14: -- Definition of the CC Header record for CC OPEN API process
15:
16: TYPE cc_header_rec_type IS RECORD (org_id igc_cc_headers.org_id%TYPE,
17: cc_type igc_cc_headers.cc_type%TYPE,
18: cc_ref_num igc_cc_headers.cc_ref_num%TYPE,
19: cc_num igc_cc_headers.cc_num%TYPE,
20: parent_header_id igc_cc_headers.parent_header_id%TYPE,
13: */
14: -- Definition of the CC Header record for CC OPEN API process
15:
16: TYPE cc_header_rec_type IS RECORD (org_id igc_cc_headers.org_id%TYPE,
17: cc_type igc_cc_headers.cc_type%TYPE,
18: cc_ref_num igc_cc_headers.cc_ref_num%TYPE,
19: cc_num igc_cc_headers.cc_num%TYPE,
20: parent_header_id igc_cc_headers.parent_header_id%TYPE,
21: vendor_id igc_cc_headers.vendor_id%TYPE,
14: -- Definition of the CC Header record for CC OPEN API process
15:
16: TYPE cc_header_rec_type IS RECORD (org_id igc_cc_headers.org_id%TYPE,
17: cc_type igc_cc_headers.cc_type%TYPE,
18: cc_ref_num igc_cc_headers.cc_ref_num%TYPE,
19: cc_num igc_cc_headers.cc_num%TYPE,
20: parent_header_id igc_cc_headers.parent_header_id%TYPE,
21: vendor_id igc_cc_headers.vendor_id%TYPE,
22: vendor_site_id igc_cc_headers.vendor_site_id%TYPE,
15:
16: TYPE cc_header_rec_type IS RECORD (org_id igc_cc_headers.org_id%TYPE,
17: cc_type igc_cc_headers.cc_type%TYPE,
18: cc_ref_num igc_cc_headers.cc_ref_num%TYPE,
19: cc_num igc_cc_headers.cc_num%TYPE,
20: parent_header_id igc_cc_headers.parent_header_id%TYPE,
21: vendor_id igc_cc_headers.vendor_id%TYPE,
22: vendor_site_id igc_cc_headers.vendor_site_id%TYPE,
23: vendor_contact_id igc_cc_headers.vendor_contact_id%TYPE,
16: TYPE cc_header_rec_type IS RECORD (org_id igc_cc_headers.org_id%TYPE,
17: cc_type igc_cc_headers.cc_type%TYPE,
18: cc_ref_num igc_cc_headers.cc_ref_num%TYPE,
19: cc_num igc_cc_headers.cc_num%TYPE,
20: parent_header_id igc_cc_headers.parent_header_id%TYPE,
21: vendor_id igc_cc_headers.vendor_id%TYPE,
22: vendor_site_id igc_cc_headers.vendor_site_id%TYPE,
23: vendor_contact_id igc_cc_headers.vendor_contact_id%TYPE,
24: term_id igc_cc_headers.term_id%TYPE,
17: cc_type igc_cc_headers.cc_type%TYPE,
18: cc_ref_num igc_cc_headers.cc_ref_num%TYPE,
19: cc_num igc_cc_headers.cc_num%TYPE,
20: parent_header_id igc_cc_headers.parent_header_id%TYPE,
21: vendor_id igc_cc_headers.vendor_id%TYPE,
22: vendor_site_id igc_cc_headers.vendor_site_id%TYPE,
23: vendor_contact_id igc_cc_headers.vendor_contact_id%TYPE,
24: term_id igc_cc_headers.term_id%TYPE,
25: location_id igc_cc_headers.location_id%TYPE,
18: cc_ref_num igc_cc_headers.cc_ref_num%TYPE,
19: cc_num igc_cc_headers.cc_num%TYPE,
20: parent_header_id igc_cc_headers.parent_header_id%TYPE,
21: vendor_id igc_cc_headers.vendor_id%TYPE,
22: vendor_site_id igc_cc_headers.vendor_site_id%TYPE,
23: vendor_contact_id igc_cc_headers.vendor_contact_id%TYPE,
24: term_id igc_cc_headers.term_id%TYPE,
25: location_id igc_cc_headers.location_id%TYPE,
26: set_of_books_id igc_cc_headers.set_of_books_id%TYPE,
19: cc_num igc_cc_headers.cc_num%TYPE,
20: parent_header_id igc_cc_headers.parent_header_id%TYPE,
21: vendor_id igc_cc_headers.vendor_id%TYPE,
22: vendor_site_id igc_cc_headers.vendor_site_id%TYPE,
23: vendor_contact_id igc_cc_headers.vendor_contact_id%TYPE,
24: term_id igc_cc_headers.term_id%TYPE,
25: location_id igc_cc_headers.location_id%TYPE,
26: set_of_books_id igc_cc_headers.set_of_books_id%TYPE,
27: cc_desc igc_cc_headers.cc_desc%TYPE,
20: parent_header_id igc_cc_headers.parent_header_id%TYPE,
21: vendor_id igc_cc_headers.vendor_id%TYPE,
22: vendor_site_id igc_cc_headers.vendor_site_id%TYPE,
23: vendor_contact_id igc_cc_headers.vendor_contact_id%TYPE,
24: term_id igc_cc_headers.term_id%TYPE,
25: location_id igc_cc_headers.location_id%TYPE,
26: set_of_books_id igc_cc_headers.set_of_books_id%TYPE,
27: cc_desc igc_cc_headers.cc_desc%TYPE,
28: cc_start_date igc_cc_headers.cc_start_date%TYPE,
21: vendor_id igc_cc_headers.vendor_id%TYPE,
22: vendor_site_id igc_cc_headers.vendor_site_id%TYPE,
23: vendor_contact_id igc_cc_headers.vendor_contact_id%TYPE,
24: term_id igc_cc_headers.term_id%TYPE,
25: location_id igc_cc_headers.location_id%TYPE,
26: set_of_books_id igc_cc_headers.set_of_books_id%TYPE,
27: cc_desc igc_cc_headers.cc_desc%TYPE,
28: cc_start_date igc_cc_headers.cc_start_date%TYPE,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,
22: vendor_site_id igc_cc_headers.vendor_site_id%TYPE,
23: vendor_contact_id igc_cc_headers.vendor_contact_id%TYPE,
24: term_id igc_cc_headers.term_id%TYPE,
25: location_id igc_cc_headers.location_id%TYPE,
26: set_of_books_id igc_cc_headers.set_of_books_id%TYPE,
27: cc_desc igc_cc_headers.cc_desc%TYPE,
28: cc_start_date igc_cc_headers.cc_start_date%TYPE,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,
23: vendor_contact_id igc_cc_headers.vendor_contact_id%TYPE,
24: term_id igc_cc_headers.term_id%TYPE,
25: location_id igc_cc_headers.location_id%TYPE,
26: set_of_books_id igc_cc_headers.set_of_books_id%TYPE,
27: cc_desc igc_cc_headers.cc_desc%TYPE,
28: cc_start_date igc_cc_headers.cc_start_date%TYPE,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,
31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_id%TYPE,
24: term_id igc_cc_headers.term_id%TYPE,
25: location_id igc_cc_headers.location_id%TYPE,
26: set_of_books_id igc_cc_headers.set_of_books_id%TYPE,
27: cc_desc igc_cc_headers.cc_desc%TYPE,
28: cc_start_date igc_cc_headers.cc_start_date%TYPE,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,
31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_id%TYPE,
32: currency_code igc_cc_headers.currency_code%TYPE,
25: location_id igc_cc_headers.location_id%TYPE,
26: set_of_books_id igc_cc_headers.set_of_books_id%TYPE,
27: cc_desc igc_cc_headers.cc_desc%TYPE,
28: cc_start_date igc_cc_headers.cc_start_date%TYPE,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,
31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_id%TYPE,
32: currency_code igc_cc_headers.currency_code%TYPE,
33: conversion_type igc_cc_headers.conversion_type%TYPE,
26: set_of_books_id igc_cc_headers.set_of_books_id%TYPE,
27: cc_desc igc_cc_headers.cc_desc%TYPE,
28: cc_start_date igc_cc_headers.cc_start_date%TYPE,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,
31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_id%TYPE,
32: currency_code igc_cc_headers.currency_code%TYPE,
33: conversion_type igc_cc_headers.conversion_type%TYPE,
34: conversion_date igc_cc_headers.conversion_date%TYPE,
27: cc_desc igc_cc_headers.cc_desc%TYPE,
28: cc_start_date igc_cc_headers.cc_start_date%TYPE,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,
31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_id%TYPE,
32: currency_code igc_cc_headers.currency_code%TYPE,
33: conversion_type igc_cc_headers.conversion_type%TYPE,
34: conversion_date igc_cc_headers.conversion_date%TYPE,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,
28: cc_start_date igc_cc_headers.cc_start_date%TYPE,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,
31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_id%TYPE,
32: currency_code igc_cc_headers.currency_code%TYPE,
33: conversion_type igc_cc_headers.conversion_type%TYPE,
34: conversion_date igc_cc_headers.conversion_date%TYPE,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,
36: last_update_date igc_cc_headers.last_update_date%TYPE,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,
31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_id%TYPE,
32: currency_code igc_cc_headers.currency_code%TYPE,
33: conversion_type igc_cc_headers.conversion_type%TYPE,
34: conversion_date igc_cc_headers.conversion_date%TYPE,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,
36: last_update_date igc_cc_headers.last_update_date%TYPE,
37: last_updated_by igc_cc_headers.last_updated_by%TYPE,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,
31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_id%TYPE,
32: currency_code igc_cc_headers.currency_code%TYPE,
33: conversion_type igc_cc_headers.conversion_type%TYPE,
34: conversion_date igc_cc_headers.conversion_date%TYPE,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,
36: last_update_date igc_cc_headers.last_update_date%TYPE,
37: last_updated_by igc_cc_headers.last_updated_by%TYPE,
38: last_update_login igc_cc_headers.last_update_login%TYPE,
31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_id%TYPE,
32: currency_code igc_cc_headers.currency_code%TYPE,
33: conversion_type igc_cc_headers.conversion_type%TYPE,
34: conversion_date igc_cc_headers.conversion_date%TYPE,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,
36: last_update_date igc_cc_headers.last_update_date%TYPE,
37: last_updated_by igc_cc_headers.last_updated_by%TYPE,
38: last_update_login igc_cc_headers.last_update_login%TYPE,
39: created_by igc_cc_headers.created_by%TYPE,
32: currency_code igc_cc_headers.currency_code%TYPE,
33: conversion_type igc_cc_headers.conversion_type%TYPE,
34: conversion_date igc_cc_headers.conversion_date%TYPE,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,
36: last_update_date igc_cc_headers.last_update_date%TYPE,
37: last_updated_by igc_cc_headers.last_updated_by%TYPE,
38: last_update_login igc_cc_headers.last_update_login%TYPE,
39: created_by igc_cc_headers.created_by%TYPE,
40: creation_date igc_cc_headers.creation_date%TYPE,
33: conversion_type igc_cc_headers.conversion_type%TYPE,
34: conversion_date igc_cc_headers.conversion_date%TYPE,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,
36: last_update_date igc_cc_headers.last_update_date%TYPE,
37: last_updated_by igc_cc_headers.last_updated_by%TYPE,
38: last_update_login igc_cc_headers.last_update_login%TYPE,
39: created_by igc_cc_headers.created_by%TYPE,
40: creation_date igc_cc_headers.creation_date%TYPE,
41: context igc_cc_headers.context%TYPE,
34: conversion_date igc_cc_headers.conversion_date%TYPE,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,
36: last_update_date igc_cc_headers.last_update_date%TYPE,
37: last_updated_by igc_cc_headers.last_updated_by%TYPE,
38: last_update_login igc_cc_headers.last_update_login%TYPE,
39: created_by igc_cc_headers.created_by%TYPE,
40: creation_date igc_cc_headers.creation_date%TYPE,
41: context igc_cc_headers.context%TYPE,
42: attribute1 igc_cc_headers.attribute1%TYPE,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,
36: last_update_date igc_cc_headers.last_update_date%TYPE,
37: last_updated_by igc_cc_headers.last_updated_by%TYPE,
38: last_update_login igc_cc_headers.last_update_login%TYPE,
39: created_by igc_cc_headers.created_by%TYPE,
40: creation_date igc_cc_headers.creation_date%TYPE,
41: context igc_cc_headers.context%TYPE,
42: attribute1 igc_cc_headers.attribute1%TYPE,
43: attribute2 igc_cc_headers.attribute2%TYPE,
36: last_update_date igc_cc_headers.last_update_date%TYPE,
37: last_updated_by igc_cc_headers.last_updated_by%TYPE,
38: last_update_login igc_cc_headers.last_update_login%TYPE,
39: created_by igc_cc_headers.created_by%TYPE,
40: creation_date igc_cc_headers.creation_date%TYPE,
41: context igc_cc_headers.context%TYPE,
42: attribute1 igc_cc_headers.attribute1%TYPE,
43: attribute2 igc_cc_headers.attribute2%TYPE,
44: attribute3 igc_cc_headers.attribute3%TYPE,
37: last_updated_by igc_cc_headers.last_updated_by%TYPE,
38: last_update_login igc_cc_headers.last_update_login%TYPE,
39: created_by igc_cc_headers.created_by%TYPE,
40: creation_date igc_cc_headers.creation_date%TYPE,
41: context igc_cc_headers.context%TYPE,
42: attribute1 igc_cc_headers.attribute1%TYPE,
43: attribute2 igc_cc_headers.attribute2%TYPE,
44: attribute3 igc_cc_headers.attribute3%TYPE,
45: attribute4 igc_cc_headers.attribute4%TYPE,
38: last_update_login igc_cc_headers.last_update_login%TYPE,
39: created_by igc_cc_headers.created_by%TYPE,
40: creation_date igc_cc_headers.creation_date%TYPE,
41: context igc_cc_headers.context%TYPE,
42: attribute1 igc_cc_headers.attribute1%TYPE,
43: attribute2 igc_cc_headers.attribute2%TYPE,
44: attribute3 igc_cc_headers.attribute3%TYPE,
45: attribute4 igc_cc_headers.attribute4%TYPE,
46: attribute5 igc_cc_headers.attribute5%TYPE,
39: created_by igc_cc_headers.created_by%TYPE,
40: creation_date igc_cc_headers.creation_date%TYPE,
41: context igc_cc_headers.context%TYPE,
42: attribute1 igc_cc_headers.attribute1%TYPE,
43: attribute2 igc_cc_headers.attribute2%TYPE,
44: attribute3 igc_cc_headers.attribute3%TYPE,
45: attribute4 igc_cc_headers.attribute4%TYPE,
46: attribute5 igc_cc_headers.attribute5%TYPE,
47: attribute6 igc_cc_headers.attribute6%TYPE,
40: creation_date igc_cc_headers.creation_date%TYPE,
41: context igc_cc_headers.context%TYPE,
42: attribute1 igc_cc_headers.attribute1%TYPE,
43: attribute2 igc_cc_headers.attribute2%TYPE,
44: attribute3 igc_cc_headers.attribute3%TYPE,
45: attribute4 igc_cc_headers.attribute4%TYPE,
46: attribute5 igc_cc_headers.attribute5%TYPE,
47: attribute6 igc_cc_headers.attribute6%TYPE,
48: attribute7 igc_cc_headers.attribute7%TYPE,
41: context igc_cc_headers.context%TYPE,
42: attribute1 igc_cc_headers.attribute1%TYPE,
43: attribute2 igc_cc_headers.attribute2%TYPE,
44: attribute3 igc_cc_headers.attribute3%TYPE,
45: attribute4 igc_cc_headers.attribute4%TYPE,
46: attribute5 igc_cc_headers.attribute5%TYPE,
47: attribute6 igc_cc_headers.attribute6%TYPE,
48: attribute7 igc_cc_headers.attribute7%TYPE,
49: attribute8 igc_cc_headers.attribute8%TYPE,
42: attribute1 igc_cc_headers.attribute1%TYPE,
43: attribute2 igc_cc_headers.attribute2%TYPE,
44: attribute3 igc_cc_headers.attribute3%TYPE,
45: attribute4 igc_cc_headers.attribute4%TYPE,
46: attribute5 igc_cc_headers.attribute5%TYPE,
47: attribute6 igc_cc_headers.attribute6%TYPE,
48: attribute7 igc_cc_headers.attribute7%TYPE,
49: attribute8 igc_cc_headers.attribute8%TYPE,
50: attribute9 igc_cc_headers.attribute9%TYPE,
43: attribute2 igc_cc_headers.attribute2%TYPE,
44: attribute3 igc_cc_headers.attribute3%TYPE,
45: attribute4 igc_cc_headers.attribute4%TYPE,
46: attribute5 igc_cc_headers.attribute5%TYPE,
47: attribute6 igc_cc_headers.attribute6%TYPE,
48: attribute7 igc_cc_headers.attribute7%TYPE,
49: attribute8 igc_cc_headers.attribute8%TYPE,
50: attribute9 igc_cc_headers.attribute9%TYPE,
51: attribute10 igc_cc_headers.attribute10%TYPE,
44: attribute3 igc_cc_headers.attribute3%TYPE,
45: attribute4 igc_cc_headers.attribute4%TYPE,
46: attribute5 igc_cc_headers.attribute5%TYPE,
47: attribute6 igc_cc_headers.attribute6%TYPE,
48: attribute7 igc_cc_headers.attribute7%TYPE,
49: attribute8 igc_cc_headers.attribute8%TYPE,
50: attribute9 igc_cc_headers.attribute9%TYPE,
51: attribute10 igc_cc_headers.attribute10%TYPE,
52: attribute11 igc_cc_headers.attribute11%TYPE,
45: attribute4 igc_cc_headers.attribute4%TYPE,
46: attribute5 igc_cc_headers.attribute5%TYPE,
47: attribute6 igc_cc_headers.attribute6%TYPE,
48: attribute7 igc_cc_headers.attribute7%TYPE,
49: attribute8 igc_cc_headers.attribute8%TYPE,
50: attribute9 igc_cc_headers.attribute9%TYPE,
51: attribute10 igc_cc_headers.attribute10%TYPE,
52: attribute11 igc_cc_headers.attribute11%TYPE,
53: attribute12 igc_cc_headers.attribute12%TYPE,
46: attribute5 igc_cc_headers.attribute5%TYPE,
47: attribute6 igc_cc_headers.attribute6%TYPE,
48: attribute7 igc_cc_headers.attribute7%TYPE,
49: attribute8 igc_cc_headers.attribute8%TYPE,
50: attribute9 igc_cc_headers.attribute9%TYPE,
51: attribute10 igc_cc_headers.attribute10%TYPE,
52: attribute11 igc_cc_headers.attribute11%TYPE,
53: attribute12 igc_cc_headers.attribute12%TYPE,
54: attribute13 igc_cc_headers.attribute13%TYPE,
47: attribute6 igc_cc_headers.attribute6%TYPE,
48: attribute7 igc_cc_headers.attribute7%TYPE,
49: attribute8 igc_cc_headers.attribute8%TYPE,
50: attribute9 igc_cc_headers.attribute9%TYPE,
51: attribute10 igc_cc_headers.attribute10%TYPE,
52: attribute11 igc_cc_headers.attribute11%TYPE,
53: attribute12 igc_cc_headers.attribute12%TYPE,
54: attribute13 igc_cc_headers.attribute13%TYPE,
55: attribute14 igc_cc_headers.attribute14%TYPE,
48: attribute7 igc_cc_headers.attribute7%TYPE,
49: attribute8 igc_cc_headers.attribute8%TYPE,
50: attribute9 igc_cc_headers.attribute9%TYPE,
51: attribute10 igc_cc_headers.attribute10%TYPE,
52: attribute11 igc_cc_headers.attribute11%TYPE,
53: attribute12 igc_cc_headers.attribute12%TYPE,
54: attribute13 igc_cc_headers.attribute13%TYPE,
55: attribute14 igc_cc_headers.attribute14%TYPE,
56: attribute15 igc_cc_headers.attribute15%TYPE,
49: attribute8 igc_cc_headers.attribute8%TYPE,
50: attribute9 igc_cc_headers.attribute9%TYPE,
51: attribute10 igc_cc_headers.attribute10%TYPE,
52: attribute11 igc_cc_headers.attribute11%TYPE,
53: attribute12 igc_cc_headers.attribute12%TYPE,
54: attribute13 igc_cc_headers.attribute13%TYPE,
55: attribute14 igc_cc_headers.attribute14%TYPE,
56: attribute15 igc_cc_headers.attribute15%TYPE,
57: cc_guarantee_flag igc_cc_headers.cc_guarantee_flag%TYPE
50: attribute9 igc_cc_headers.attribute9%TYPE,
51: attribute10 igc_cc_headers.attribute10%TYPE,
52: attribute11 igc_cc_headers.attribute11%TYPE,
53: attribute12 igc_cc_headers.attribute12%TYPE,
54: attribute13 igc_cc_headers.attribute13%TYPE,
55: attribute14 igc_cc_headers.attribute14%TYPE,
56: attribute15 igc_cc_headers.attribute15%TYPE,
57: cc_guarantee_flag igc_cc_headers.cc_guarantee_flag%TYPE
58: );
51: attribute10 igc_cc_headers.attribute10%TYPE,
52: attribute11 igc_cc_headers.attribute11%TYPE,
53: attribute12 igc_cc_headers.attribute12%TYPE,
54: attribute13 igc_cc_headers.attribute13%TYPE,
55: attribute14 igc_cc_headers.attribute14%TYPE,
56: attribute15 igc_cc_headers.attribute15%TYPE,
57: cc_guarantee_flag igc_cc_headers.cc_guarantee_flag%TYPE
58: );
59:
52: attribute11 igc_cc_headers.attribute11%TYPE,
53: attribute12 igc_cc_headers.attribute12%TYPE,
54: attribute13 igc_cc_headers.attribute13%TYPE,
55: attribute14 igc_cc_headers.attribute14%TYPE,
56: attribute15 igc_cc_headers.attribute15%TYPE,
57: cc_guarantee_flag igc_cc_headers.cc_guarantee_flag%TYPE
58: );
59:
60: -- Main program which selects all the records from Header PL-SQL table
53: attribute12 igc_cc_headers.attribute12%TYPE,
54: attribute13 igc_cc_headers.attribute13%TYPE,
55: attribute14 igc_cc_headers.attribute14%TYPE,
56: attribute15 igc_cc_headers.attribute15%TYPE,
57: cc_guarantee_flag igc_cc_headers.cc_guarantee_flag%TYPE
58: );
59:
60: -- Main program which selects all the records from Header PL-SQL table
61: -- and calls other programs for processing
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 ,
133: p_commit IN VARCHAR2,
134: p_validation_level IN NUMBER,
135: p_cc_num IN igc_cc_headers.cc_num%TYPE,
136: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
137: p_org_id IN igc_cc_headers.org_id%TYPE,
138: p_action_code IN fnd_lookups.lookup_code%TYPE,
139: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
132: p_init_msg_list IN VARCHAR2 ,
133: p_commit IN VARCHAR2,
134: p_validation_level IN NUMBER,
135: p_cc_num IN igc_cc_headers.cc_num%TYPE,
136: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
137: p_org_id IN igc_cc_headers.org_id%TYPE,
138: p_action_code IN fnd_lookups.lookup_code%TYPE,
139: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
140: p_last_update_login IN igc_cc_headers.last_update_login%TYPE,
133: p_commit IN VARCHAR2,
134: p_validation_level IN NUMBER,
135: p_cc_num IN igc_cc_headers.cc_num%TYPE,
136: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
137: p_org_id IN igc_cc_headers.org_id%TYPE,
138: p_action_code IN fnd_lookups.lookup_code%TYPE,
139: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
140: p_last_update_login IN igc_cc_headers.last_update_login%TYPE,
141: x_return_status OUT NOCOPY VARCHAR2,
135: p_cc_num IN igc_cc_headers.cc_num%TYPE,
136: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
137: p_org_id IN igc_cc_headers.org_id%TYPE,
138: p_action_code IN fnd_lookups.lookup_code%TYPE,
139: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
140: p_last_update_login IN igc_cc_headers.last_update_login%TYPE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2
136: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
137: p_org_id IN igc_cc_headers.org_id%TYPE,
138: p_action_code IN fnd_lookups.lookup_code%TYPE,
139: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
140: p_last_update_login IN igc_cc_headers.last_update_login%TYPE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2
144: );
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2,
181: p_commit IN VARCHAR2,
182: p_validation_level IN NUMBER,
183: p_cc_num IN igc_cc_headers.cc_num%TYPE,
184: p_org_id IN igc_cc_headers.org_id%TYPE,
185: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
186: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
187: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
180: p_init_msg_list IN VARCHAR2,
181: p_commit IN VARCHAR2,
182: p_validation_level IN NUMBER,
183: p_cc_num IN igc_cc_headers.cc_num%TYPE,
184: p_org_id IN igc_cc_headers.org_id%TYPE,
185: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
186: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
187: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
188: x_return_status OUT NOCOPY VARCHAR2,
181: p_commit IN VARCHAR2,
182: p_validation_level IN NUMBER,
183: p_cc_num IN igc_cc_headers.cc_num%TYPE,
184: p_org_id IN igc_cc_headers.org_id%TYPE,
185: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
186: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
187: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
182: p_validation_level IN NUMBER,
183: p_cc_num IN igc_cc_headers.cc_num%TYPE,
184: p_org_id IN igc_cc_headers.org_id%TYPE,
185: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
186: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
187: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2
183: p_cc_num IN igc_cc_headers.cc_num%TYPE,
184: p_org_id IN igc_cc_headers.org_id%TYPE,
185: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
186: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
187: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2
191: );
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2,
226: p_commit IN VARCHAR2,
227: p_validation_level IN NUMBER,
228: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,
229: p_org_id IN igc_cc_headers.org_id%TYPE,
230: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
231: p_cc_num IN igc_cc_headers.cc_num%TYPE,
232: x_return_status OUT NOCOPY VARCHAR2,
225: p_init_msg_list IN VARCHAR2,
226: p_commit IN VARCHAR2,
227: p_validation_level IN NUMBER,
228: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,
229: p_org_id IN igc_cc_headers.org_id%TYPE,
230: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
231: p_cc_num IN igc_cc_headers.cc_num%TYPE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
226: p_commit IN VARCHAR2,
227: p_validation_level IN NUMBER,
228: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,
229: p_org_id IN igc_cc_headers.org_id%TYPE,
230: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
231: p_cc_num IN igc_cc_headers.cc_num%TYPE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2
227: p_validation_level IN NUMBER,
228: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,
229: p_org_id IN igc_cc_headers.org_id%TYPE,
230: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
231: p_cc_num IN igc_cc_headers.cc_num%TYPE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2
235: );