DBA Data[Home] [Help]

APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on IGC_CC_HEADERS

Line 16: TYPE cc_header_rec_type IS RECORD (org_id igc_cc_headers.org_id%TYPE,

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,

Line 17: cc_type igc_cc_headers.cc_type%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,

Line 18: cc_ref_num igc_cc_headers.cc_ref_num%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,

Line 19: cc_num igc_cc_headers.cc_num%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,

Line 20: parent_header_id igc_cc_headers.parent_header_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,

Line 21: vendor_id igc_cc_headers.vendor_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,

Line 22: vendor_site_id igc_cc_headers.vendor_site_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,

Line 23: vendor_contact_id igc_cc_headers.vendor_contact_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,

Line 24: term_id igc_cc_headers.term_id%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,

Line 25: location_id igc_cc_headers.location_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,
29: cc_end_date igc_cc_headers.cc_end_date%TYPE,

Line 26: set_of_books_id igc_cc_headers.set_of_books_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,
30: cc_owner_user_id igc_cc_headers.cc_owner_user_id%TYPE,

Line 27: cc_desc igc_cc_headers.cc_desc%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,

Line 28: cc_start_date igc_cc_headers.cc_start_date%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,

Line 29: cc_end_date igc_cc_headers.cc_end_date%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,

Line 30: cc_owner_user_id igc_cc_headers.cc_owner_user_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,
34: conversion_date igc_cc_headers.conversion_date%TYPE,

Line 31: cc_preparer_user_id igc_cc_headers.cc_preparer_user_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,
35: conversion_rate igc_cc_headers.conversion_rate%TYPE,

Line 32: currency_code igc_cc_headers.currency_code%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,

Line 33: conversion_type igc_cc_headers.conversion_type%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,

Line 34: conversion_date igc_cc_headers.conversion_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,
38: last_update_login igc_cc_headers.last_update_login%TYPE,

Line 35: conversion_rate igc_cc_headers.conversion_rate%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,

Line 36: last_update_date igc_cc_headers.last_update_date%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,

Line 37: last_updated_by igc_cc_headers.last_updated_by%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,

Line 38: last_update_login igc_cc_headers.last_update_login%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,

Line 39: created_by igc_cc_headers.created_by%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,

Line 40: creation_date igc_cc_headers.creation_date%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,

Line 41: context igc_cc_headers.context%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,

Line 42: attribute1 igc_cc_headers.attribute1%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,

Line 43: attribute2 igc_cc_headers.attribute2%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,

Line 44: attribute3 igc_cc_headers.attribute3%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,

Line 45: attribute4 igc_cc_headers.attribute4%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,

Line 46: attribute5 igc_cc_headers.attribute5%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,

Line 47: attribute6 igc_cc_headers.attribute6%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,

Line 48: attribute7 igc_cc_headers.attribute7%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,

Line 49: attribute8 igc_cc_headers.attribute8%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,

Line 50: attribute9 igc_cc_headers.attribute9%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,

Line 51: attribute10 igc_cc_headers.attribute10%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,

Line 52: attribute11 igc_cc_headers.attribute11%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,

Line 53: attribute12 igc_cc_headers.attribute12%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

Line 54: attribute13 igc_cc_headers.attribute13%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: );

Line 55: attribute14 igc_cc_headers.attribute14%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: );
59:

Line 56: attribute15 igc_cc_headers.attribute15%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:
60: -- Main program which selects all the records from Header PL-SQL table

Line 57: cc_guarantee_flag igc_cc_headers.cc_guarantee_flag%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
61: -- and calls other programs for processing

Line 135: p_cc_num IN igc_cc_headers.cc_num%TYPE,

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,

Line 136: p_set_of_books_id IN igc_cc_headers.set_of_books_id%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,

Line 137: p_org_id IN igc_cc_headers.org_id%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,

Line 139: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,

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

Line 140: p_last_update_login IN igc_cc_headers.last_update_login%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
144: );

Line 183: p_cc_num IN igc_cc_headers.cc_num%TYPE,

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,

Line 184: p_org_id IN igc_cc_headers.org_id%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,

Line 185: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,

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,

Line 186: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,

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

Line 187: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,

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

Line 228: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,

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,

Line 229: p_org_id IN igc_cc_headers.org_id%TYPE,

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,

Line 230: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,

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

Line 231: p_cc_num IN igc_cc_headers.cc_num%TYPE,

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