eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSP_REQUIREMENT_LINES_PUB dependencies on FND_API

Line 47: WHERE decode(nvl(l_RQL_rec.SEGMENT1, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT1) = nvl(SEGMENT1, '####')

43: -- Hint: Declare cursor and local variables
44: CURSOR C_Get_Item_Id IS
45: SELECT inventory_item_id
46: FROM mtl_system_items_b
47: WHERE decode(nvl(l_RQL_rec.SEGMENT1, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT1) = nvl(SEGMENT1, '####')
48: AND decode(nvl(l_RQL_rec.SEGMENT2, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT2) = nvl(SEGMENT2, '####')
49: AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')
50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')
51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')

Line 48: AND decode(nvl(l_RQL_rec.SEGMENT2, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT2) = nvl(SEGMENT2, '####')

44: CURSOR C_Get_Item_Id IS
45: SELECT inventory_item_id
46: FROM mtl_system_items_b
47: WHERE decode(nvl(l_RQL_rec.SEGMENT1, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT1) = nvl(SEGMENT1, '####')
48: AND decode(nvl(l_RQL_rec.SEGMENT2, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT2) = nvl(SEGMENT2, '####')
49: AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')
50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')
51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')
52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')

Line 49: AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')

45: SELECT inventory_item_id
46: FROM mtl_system_items_b
47: WHERE decode(nvl(l_RQL_rec.SEGMENT1, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT1) = nvl(SEGMENT1, '####')
48: AND decode(nvl(l_RQL_rec.SEGMENT2, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT2) = nvl(SEGMENT2, '####')
49: AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')
50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')
51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')
52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')
53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')

Line 50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')

46: FROM mtl_system_items_b
47: WHERE decode(nvl(l_RQL_rec.SEGMENT1, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT1) = nvl(SEGMENT1, '####')
48: AND decode(nvl(l_RQL_rec.SEGMENT2, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT2) = nvl(SEGMENT2, '####')
49: AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')
50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')
51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')
52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')
53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')
54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')

Line 51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')

47: WHERE decode(nvl(l_RQL_rec.SEGMENT1, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT1) = nvl(SEGMENT1, '####')
48: AND decode(nvl(l_RQL_rec.SEGMENT2, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT2) = nvl(SEGMENT2, '####')
49: AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')
50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')
51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')
52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')
53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')
54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')
55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')

Line 52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')

48: AND decode(nvl(l_RQL_rec.SEGMENT2, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT2) = nvl(SEGMENT2, '####')
49: AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')
50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')
51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')
52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')
53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')
54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')
55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')
56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')

Line 53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')

49: AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')
50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')
51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')
52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')
53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')
54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')
55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')
56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')
57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')

Line 54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')

50: AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')
51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')
52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')
53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')
54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')
55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')
56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')
57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')
58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')

Line 55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')

51: AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')
52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')
53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')
54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')
55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')
56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')
57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')
58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')
59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')

Line 56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')

52: AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')
53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')
54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')
55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')
56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')
57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')
58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')
59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')
60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')

Line 57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')

53: AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')
54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')
55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')
56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')
57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')
58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')
59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')
60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')
61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')

Line 58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')

54: AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')
55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')
56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')
57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')
58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')
59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')
60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')
61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')
62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')

Line 59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')

55: AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')
56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')
57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')
58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')
59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')
60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')
61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')
62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')
63: AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')

Line 60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')

56: AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')
57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')
58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')
59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')
60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')
61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')
62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')
63: AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')
64: AND decode(nvl(l_RQL_rec.SEGMENT18, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT18) = nvl(SEGMENT18, '####')

Line 61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')

57: AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')
58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')
59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')
60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')
61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')
62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')
63: AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')
64: AND decode(nvl(l_RQL_rec.SEGMENT18, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT18) = nvl(SEGMENT18, '####')
65: AND decode(nvl(l_RQL_rec.SEGMENT19, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT19) = nvl(SEGMENT19, '####')

Line 62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')

58: AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')
59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')
60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')
61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')
62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')
63: AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')
64: AND decode(nvl(l_RQL_rec.SEGMENT18, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT18) = nvl(SEGMENT18, '####')
65: AND decode(nvl(l_RQL_rec.SEGMENT19, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT19) = nvl(SEGMENT19, '####')
66: AND decode(nvl(l_RQL_rec.SEGMENT20, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT20) = nvl(SEGMENT20, '####')

Line 63: AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')

59: AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')
60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')
61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')
62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')
63: AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')
64: AND decode(nvl(l_RQL_rec.SEGMENT18, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT18) = nvl(SEGMENT18, '####')
65: AND decode(nvl(l_RQL_rec.SEGMENT19, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT19) = nvl(SEGMENT19, '####')
66: AND decode(nvl(l_RQL_rec.SEGMENT20, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT20) = nvl(SEGMENT20, '####')
67: AND organization_id = cs_std.get_item_valdn_orgzn_id;

Line 64: AND decode(nvl(l_RQL_rec.SEGMENT18, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT18) = nvl(SEGMENT18, '####')

60: AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')
61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')
62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')
63: AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')
64: AND decode(nvl(l_RQL_rec.SEGMENT18, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT18) = nvl(SEGMENT18, '####')
65: AND decode(nvl(l_RQL_rec.SEGMENT19, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT19) = nvl(SEGMENT19, '####')
66: AND decode(nvl(l_RQL_rec.SEGMENT20, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT20) = nvl(SEGMENT20, '####')
67: AND organization_id = cs_std.get_item_valdn_orgzn_id;
68: EXCP_USER_DEFINED EXCEPTION;

Line 65: AND decode(nvl(l_RQL_rec.SEGMENT19, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT19) = nvl(SEGMENT19, '####')

61: AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')
62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')
63: AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')
64: AND decode(nvl(l_RQL_rec.SEGMENT18, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT18) = nvl(SEGMENT18, '####')
65: AND decode(nvl(l_RQL_rec.SEGMENT19, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT19) = nvl(SEGMENT19, '####')
66: AND decode(nvl(l_RQL_rec.SEGMENT20, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT20) = nvl(SEGMENT20, '####')
67: AND organization_id = cs_std.get_item_valdn_orgzn_id;
68: EXCP_USER_DEFINED EXCEPTION;
69: BEGIN

Line 66: AND decode(nvl(l_RQL_rec.SEGMENT20, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT20) = nvl(SEGMENT20, '####')

62: AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')
63: AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')
64: AND decode(nvl(l_RQL_rec.SEGMENT18, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT18) = nvl(SEGMENT18, '####')
65: AND decode(nvl(l_RQL_rec.SEGMENT19, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT19) = nvl(SEGMENT19, '####')
66: AND decode(nvl(l_RQL_rec.SEGMENT20, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT20) = nvl(SEGMENT20, '####')
67: AND organization_id = cs_std.get_item_valdn_orgzn_id;
68: EXCP_USER_DEFINED EXCEPTION;
69: BEGIN
70: FOR I IN 1..p_RQL_Tbl.count LOOP

Line 72: If(l_RQL_rec.inventory_item_id is NOT NULL and l_RQL_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN

68: EXCP_USER_DEFINED EXCEPTION;
69: BEGIN
70: FOR I IN 1..p_RQL_Tbl.count LOOP
71: l_RQL_rec := P_RQL_Tbl(I);
72: If(l_RQL_rec.inventory_item_id is NOT NULL and l_RQL_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
73: x_pvt_RQL_Tbl(I).inventory_item_id := l_RQL_rec.inventory_item_id;
74: ELSIF((l_RQL_rec.SEGMENT1 is NOT NULL and l_RQL_rec.SEGMENT1 <> FND_API.G_MISS_CHAR) OR
75: (l_RQL_rec.SEGMENT2 is NOT NULL and l_RQL_rec.SEGMENT2 <> FND_API.G_MISS_CHAR) OR
76: (l_RQL_rec.SEGMENT3 is NOT NULL and l_RQL_rec.SEGMENT3 <> FND_API.G_MISS_CHAR) OR

Line 74: ELSIF((l_RQL_rec.SEGMENT1 is NOT NULL and l_RQL_rec.SEGMENT1 <> FND_API.G_MISS_CHAR) OR

70: FOR I IN 1..p_RQL_Tbl.count LOOP
71: l_RQL_rec := P_RQL_Tbl(I);
72: If(l_RQL_rec.inventory_item_id is NOT NULL and l_RQL_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
73: x_pvt_RQL_Tbl(I).inventory_item_id := l_RQL_rec.inventory_item_id;
74: ELSIF((l_RQL_rec.SEGMENT1 is NOT NULL and l_RQL_rec.SEGMENT1 <> FND_API.G_MISS_CHAR) OR
75: (l_RQL_rec.SEGMENT2 is NOT NULL and l_RQL_rec.SEGMENT2 <> FND_API.G_MISS_CHAR) OR
76: (l_RQL_rec.SEGMENT3 is NOT NULL and l_RQL_rec.SEGMENT3 <> FND_API.G_MISS_CHAR) OR
77: (l_RQL_rec.SEGMENT4 is NOT NULL and l_RQL_rec.SEGMENT4 <> FND_API.G_MISS_CHAR) OR
78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR

Line 75: (l_RQL_rec.SEGMENT2 is NOT NULL and l_RQL_rec.SEGMENT2 <> FND_API.G_MISS_CHAR) OR

71: l_RQL_rec := P_RQL_Tbl(I);
72: If(l_RQL_rec.inventory_item_id is NOT NULL and l_RQL_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
73: x_pvt_RQL_Tbl(I).inventory_item_id := l_RQL_rec.inventory_item_id;
74: ELSIF((l_RQL_rec.SEGMENT1 is NOT NULL and l_RQL_rec.SEGMENT1 <> FND_API.G_MISS_CHAR) OR
75: (l_RQL_rec.SEGMENT2 is NOT NULL and l_RQL_rec.SEGMENT2 <> FND_API.G_MISS_CHAR) OR
76: (l_RQL_rec.SEGMENT3 is NOT NULL and l_RQL_rec.SEGMENT3 <> FND_API.G_MISS_CHAR) OR
77: (l_RQL_rec.SEGMENT4 is NOT NULL and l_RQL_rec.SEGMENT4 <> FND_API.G_MISS_CHAR) OR
78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR
79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR

Line 76: (l_RQL_rec.SEGMENT3 is NOT NULL and l_RQL_rec.SEGMENT3 <> FND_API.G_MISS_CHAR) OR

72: If(l_RQL_rec.inventory_item_id is NOT NULL and l_RQL_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
73: x_pvt_RQL_Tbl(I).inventory_item_id := l_RQL_rec.inventory_item_id;
74: ELSIF((l_RQL_rec.SEGMENT1 is NOT NULL and l_RQL_rec.SEGMENT1 <> FND_API.G_MISS_CHAR) OR
75: (l_RQL_rec.SEGMENT2 is NOT NULL and l_RQL_rec.SEGMENT2 <> FND_API.G_MISS_CHAR) OR
76: (l_RQL_rec.SEGMENT3 is NOT NULL and l_RQL_rec.SEGMENT3 <> FND_API.G_MISS_CHAR) OR
77: (l_RQL_rec.SEGMENT4 is NOT NULL and l_RQL_rec.SEGMENT4 <> FND_API.G_MISS_CHAR) OR
78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR
79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR
80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR

Line 77: (l_RQL_rec.SEGMENT4 is NOT NULL and l_RQL_rec.SEGMENT4 <> FND_API.G_MISS_CHAR) OR

73: x_pvt_RQL_Tbl(I).inventory_item_id := l_RQL_rec.inventory_item_id;
74: ELSIF((l_RQL_rec.SEGMENT1 is NOT NULL and l_RQL_rec.SEGMENT1 <> FND_API.G_MISS_CHAR) OR
75: (l_RQL_rec.SEGMENT2 is NOT NULL and l_RQL_rec.SEGMENT2 <> FND_API.G_MISS_CHAR) OR
76: (l_RQL_rec.SEGMENT3 is NOT NULL and l_RQL_rec.SEGMENT3 <> FND_API.G_MISS_CHAR) OR
77: (l_RQL_rec.SEGMENT4 is NOT NULL and l_RQL_rec.SEGMENT4 <> FND_API.G_MISS_CHAR) OR
78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR
79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR
80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR
81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR

Line 78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR

74: ELSIF((l_RQL_rec.SEGMENT1 is NOT NULL and l_RQL_rec.SEGMENT1 <> FND_API.G_MISS_CHAR) OR
75: (l_RQL_rec.SEGMENT2 is NOT NULL and l_RQL_rec.SEGMENT2 <> FND_API.G_MISS_CHAR) OR
76: (l_RQL_rec.SEGMENT3 is NOT NULL and l_RQL_rec.SEGMENT3 <> FND_API.G_MISS_CHAR) OR
77: (l_RQL_rec.SEGMENT4 is NOT NULL and l_RQL_rec.SEGMENT4 <> FND_API.G_MISS_CHAR) OR
78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR
79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR
80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR
81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR
82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR

Line 79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR

75: (l_RQL_rec.SEGMENT2 is NOT NULL and l_RQL_rec.SEGMENT2 <> FND_API.G_MISS_CHAR) OR
76: (l_RQL_rec.SEGMENT3 is NOT NULL and l_RQL_rec.SEGMENT3 <> FND_API.G_MISS_CHAR) OR
77: (l_RQL_rec.SEGMENT4 is NOT NULL and l_RQL_rec.SEGMENT4 <> FND_API.G_MISS_CHAR) OR
78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR
79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR
80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR
81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR
82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR
83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR

Line 80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR

76: (l_RQL_rec.SEGMENT3 is NOT NULL and l_RQL_rec.SEGMENT3 <> FND_API.G_MISS_CHAR) OR
77: (l_RQL_rec.SEGMENT4 is NOT NULL and l_RQL_rec.SEGMENT4 <> FND_API.G_MISS_CHAR) OR
78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR
79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR
80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR
81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR
82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR
83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR
84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR

Line 81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR

77: (l_RQL_rec.SEGMENT4 is NOT NULL and l_RQL_rec.SEGMENT4 <> FND_API.G_MISS_CHAR) OR
78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR
79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR
80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR
81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR
82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR
83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR
84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR
85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR

Line 82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR

78: (l_RQL_rec.SEGMENT5 is NOT NULL and l_RQL_rec.SEGMENT5 <> FND_API.G_MISS_CHAR) OR
79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR
80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR
81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR
82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR
83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR
84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR
85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR
86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR

Line 83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR

79: (l_RQL_rec.SEGMENT6 is NOT NULL and l_RQL_rec.SEGMENT6 <> FND_API.G_MISS_CHAR) OR
80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR
81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR
82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR
83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR
84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR
85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR
86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR
87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR

Line 84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR

80: (l_RQL_rec.SEGMENT7 is NOT NULL and l_RQL_rec.SEGMENT7 <> FND_API.G_MISS_CHAR) OR
81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR
82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR
83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR
84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR
85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR
86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR
87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR
88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR

Line 85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR

81: (l_RQL_rec.SEGMENT8 is NOT NULL and l_RQL_rec.SEGMENT8 <> FND_API.G_MISS_CHAR) OR
82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR
83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR
84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR
85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR
86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR
87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR
88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR
89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR

Line 86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR

82: (l_RQL_rec.SEGMENT9 is NOT NULL and l_RQL_rec.SEGMENT9 <> FND_API.G_MISS_CHAR) OR
83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR
84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR
85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR
86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR
87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR
88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR
89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR
90: (l_RQL_rec.SEGMENT17 is NOT NULL and l_RQL_rec.SEGMENT17 <> FND_API.G_MISS_CHAR) OR

Line 87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR

83: (l_RQL_rec.SEGMENT10 is NOT NULL and l_RQL_rec.SEGMENT10 <> FND_API.G_MISS_CHAR) OR
84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR
85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR
86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR
87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR
88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR
89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR
90: (l_RQL_rec.SEGMENT17 is NOT NULL and l_RQL_rec.SEGMENT17 <> FND_API.G_MISS_CHAR) OR
91: (l_RQL_rec.SEGMENT18 is NOT NULL and l_RQL_rec.SEGMENT18 <> FND_API.G_MISS_CHAR) OR

Line 88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR

84: (l_RQL_rec.SEGMENT11 is NOT NULL and l_RQL_rec.SEGMENT11 <> FND_API.G_MISS_CHAR) OR
85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR
86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR
87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR
88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR
89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR
90: (l_RQL_rec.SEGMENT17 is NOT NULL and l_RQL_rec.SEGMENT17 <> FND_API.G_MISS_CHAR) OR
91: (l_RQL_rec.SEGMENT18 is NOT NULL and l_RQL_rec.SEGMENT18 <> FND_API.G_MISS_CHAR) OR
92: (l_RQL_rec.SEGMENT19 is NOT NULL and l_RQL_rec.SEGMENT19 <> FND_API.G_MISS_CHAR) OR

Line 89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR

85: (l_RQL_rec.SEGMENT12 is NOT NULL and l_RQL_rec.SEGMENT12 <> FND_API.G_MISS_CHAR) OR
86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR
87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR
88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR
89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR
90: (l_RQL_rec.SEGMENT17 is NOT NULL and l_RQL_rec.SEGMENT17 <> FND_API.G_MISS_CHAR) OR
91: (l_RQL_rec.SEGMENT18 is NOT NULL and l_RQL_rec.SEGMENT18 <> FND_API.G_MISS_CHAR) OR
92: (l_RQL_rec.SEGMENT19 is NOT NULL and l_RQL_rec.SEGMENT19 <> FND_API.G_MISS_CHAR) OR
93: (l_RQL_rec.SEGMENT20 is NOT NULL and l_RQL_rec.SEGMENT20 <> FND_API.G_MISS_CHAR))

Line 90: (l_RQL_rec.SEGMENT17 is NOT NULL and l_RQL_rec.SEGMENT17 <> FND_API.G_MISS_CHAR) OR

86: (l_RQL_rec.SEGMENT13 is NOT NULL and l_RQL_rec.SEGMENT13 <> FND_API.G_MISS_CHAR) OR
87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR
88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR
89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR
90: (l_RQL_rec.SEGMENT17 is NOT NULL and l_RQL_rec.SEGMENT17 <> FND_API.G_MISS_CHAR) OR
91: (l_RQL_rec.SEGMENT18 is NOT NULL and l_RQL_rec.SEGMENT18 <> FND_API.G_MISS_CHAR) OR
92: (l_RQL_rec.SEGMENT19 is NOT NULL and l_RQL_rec.SEGMENT19 <> FND_API.G_MISS_CHAR) OR
93: (l_RQL_rec.SEGMENT20 is NOT NULL and l_RQL_rec.SEGMENT20 <> FND_API.G_MISS_CHAR))
94: THEN

Line 91: (l_RQL_rec.SEGMENT18 is NOT NULL and l_RQL_rec.SEGMENT18 <> FND_API.G_MISS_CHAR) OR

87: (l_RQL_rec.SEGMENT14 is NOT NULL and l_RQL_rec.SEGMENT14 <> FND_API.G_MISS_CHAR) OR
88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR
89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR
90: (l_RQL_rec.SEGMENT17 is NOT NULL and l_RQL_rec.SEGMENT17 <> FND_API.G_MISS_CHAR) OR
91: (l_RQL_rec.SEGMENT18 is NOT NULL and l_RQL_rec.SEGMENT18 <> FND_API.G_MISS_CHAR) OR
92: (l_RQL_rec.SEGMENT19 is NOT NULL and l_RQL_rec.SEGMENT19 <> FND_API.G_MISS_CHAR) OR
93: (l_RQL_rec.SEGMENT20 is NOT NULL and l_RQL_rec.SEGMENT20 <> FND_API.G_MISS_CHAR))
94: THEN
95: OPEN C_Get_Item_Id;

Line 92: (l_RQL_rec.SEGMENT19 is NOT NULL and l_RQL_rec.SEGMENT19 <> FND_API.G_MISS_CHAR) OR

88: (l_RQL_rec.SEGMENT15 is NOT NULL and l_RQL_rec.SEGMENT15 <> FND_API.G_MISS_CHAR) OR
89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR
90: (l_RQL_rec.SEGMENT17 is NOT NULL and l_RQL_rec.SEGMENT17 <> FND_API.G_MISS_CHAR) OR
91: (l_RQL_rec.SEGMENT18 is NOT NULL and l_RQL_rec.SEGMENT18 <> FND_API.G_MISS_CHAR) OR
92: (l_RQL_rec.SEGMENT19 is NOT NULL and l_RQL_rec.SEGMENT19 <> FND_API.G_MISS_CHAR) OR
93: (l_RQL_rec.SEGMENT20 is NOT NULL and l_RQL_rec.SEGMENT20 <> FND_API.G_MISS_CHAR))
94: THEN
95: OPEN C_Get_Item_Id;
96: FETCH C_Get_Item_Id INTO l_inventory_item_id;

Line 93: (l_RQL_rec.SEGMENT20 is NOT NULL and l_RQL_rec.SEGMENT20 <> FND_API.G_MISS_CHAR))

89: (l_RQL_rec.SEGMENT16 is NOT NULL and l_RQL_rec.SEGMENT16 <> FND_API.G_MISS_CHAR) OR
90: (l_RQL_rec.SEGMENT17 is NOT NULL and l_RQL_rec.SEGMENT17 <> FND_API.G_MISS_CHAR) OR
91: (l_RQL_rec.SEGMENT18 is NOT NULL and l_RQL_rec.SEGMENT18 <> FND_API.G_MISS_CHAR) OR
92: (l_RQL_rec.SEGMENT19 is NOT NULL and l_RQL_rec.SEGMENT19 <> FND_API.G_MISS_CHAR) OR
93: (l_RQL_rec.SEGMENT20 is NOT NULL and l_RQL_rec.SEGMENT20 <> FND_API.G_MISS_CHAR))
94: THEN
95: OPEN C_Get_Item_Id;
96: FETCH C_Get_Item_Id INTO l_inventory_item_id;
97: IF C_Get_Item_Id%NOTFOUND THEN

Line 157: raise FND_API.G_EXC_ERROR;

153: END LOOP;
154: -- If there is an error in conversion precessing, raise an error.
155: /* IF l_any_errors
156: THEN
157: raise FND_API.G_EXC_ERROR;
158: END IF;
159: */
160: END Convert_RQL_Values_To_Ids;
161:

Line 168: AND l_pvt_RQL_Tbl(I).requirement_header_id <> FND_API.G_MISS_NUM)THEN

164: EXCP_USER_DEFINED EXCEPTION;
165: BEGIN
166: FOR I IN 1..l_pvt_RQL_TBL.COUNT LOOP
167: IF (l_pvt_RQL_Tbl(I).requirement_header_id IS NOT NULL
168: AND l_pvt_RQL_Tbl(I).requirement_header_id <> FND_API.G_MISS_NUM)THEN
169: BEGIN
170: SELECT count(requirement_header_id)
171: INTO l_count
172: FROM csp_requirement_headers

Line 186: AND l_pvt_RQL_Tbl(I).inventory_item_id <> FND_API.G_MISS_NUM) THEN

182: null;
183: END;
184: END IF;
185: IF (l_pvt_RQL_Tbl(I).inventory_item_id IS NOT NULL
186: AND l_pvt_RQL_Tbl(I).inventory_item_id <> FND_API.G_MISS_NUM) THEN
187: BEGIN
188: SELECT count(inventory_item_id)
189: INTO l_count
190: FROM mtl_system_items_b

Line 203: AND l_pvt_RQL_Tbl(I).source_organization_id <> FND_API.G_MISS_NUM) THEN

199: null;
200: END;
201: END IF;
202: IF (l_pvt_RQL_Tbl(I).source_organization_id IS NOT NULL
203: AND l_pvt_RQL_Tbl(I).source_organization_id <> FND_API.G_MISS_NUM) THEN
204: BEGIN
205: SELECT count(organization_id)
206: INTO l_count
207: FROM mtl_parameters

Line 221: AND l_pvt_RQL_Tbl(I).uom_code <> FND_API.G_MISS_CHAR) THEN

217: null;
218: END;
219: END IF;
220: IF (l_pvt_RQL_Tbl(I).uom_code IS NOT NULL
221: AND l_pvt_RQL_Tbl(I).uom_code <> FND_API.G_MISS_CHAR) THEN
222: BEGIN
223: SELECT count(uom_code)
224: INTO l_count
225: FROM mtl_item_uoms_view

Line 228: decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)

224: INTO l_count
225: FROM mtl_item_uoms_view
226: WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id
227: AND organization_id =
228: decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)
229: AND uom_code = l_pvt_RQL_Tbl(I).uom_code;
230: IF (l_count <= 0) THEN
231: FND_MESSAGE.SET_NAME ('WSH', 'WSH_OI_INVALID_UOM');
232: FND_MSG_PUB.ADD;

Line 241: AND l_pvt_RQL_Tbl(I).revision <> FND_API.G_MISS_CHAR) THEN

237: null;
238: END;
239: END IF;
240: IF (l_pvt_RQL_Tbl(I).revision IS NOT NULL
241: AND l_pvt_RQL_Tbl(I).revision <> FND_API.G_MISS_CHAR) THEN
242: BEGIN
243: SELECT count(revision)
244: INTO l_count
245: FROM mtl_item_revisions

Line 248: decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)

244: INTO l_count
245: FROM mtl_item_revisions
246: WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id
247: AND organization_id =
248: decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)
249: AND revision = l_pvt_RQL_Tbl(I).revision;
250: IF (l_count <= 0) THEN
251: FND_MESSAGE.SET_NAME ('INV', 'INV_INT_REVCODE');
252: FND_MSG_PUB.ADD;

Line 265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

261: END;
262:
263: PROCEDURE Create_REQUIREMENT_LINES(
264: P_Api_Version_Number IN NUMBER,
265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
267: P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_Tbl,
268: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
269: X_REQUIREMENT_LINE_TBL OUT NOCOPY RQL_Tbl_Type,

Line 266: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

262:
263: PROCEDURE Create_REQUIREMENT_LINES(
264: P_Api_Version_Number IN NUMBER,
265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
267: P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_Tbl,
268: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
269: X_REQUIREMENT_LINE_TBL OUT NOCOPY RQL_Tbl_Type,
270: X_Return_Status OUT NOCOPY VARCHAR2,

Line 286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

282: -- Standard Start of API savepoint
283: SAVEPOINT CREATE_REQUIREMENT_LINES_PUB;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
287: p_api_version_number,
288: l_api_name,
289: G_PKG_NAME)
290: THEN

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

287: p_api_version_number,
288: l_api_name,
289: G_PKG_NAME)
290: THEN
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294:
295: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 296: IF FND_API.to_Boolean( p_init_msg_list )

292: END IF;
293:
294:
295: -- Initialize message list if p_init_msg_list is set to TRUE.
296: IF FND_API.to_Boolean( p_init_msg_list )
297: THEN
298: FND_MSG_PUB.initialize;
299: END IF;
300:

Line 307: x_return_status := FND_API.G_RET_STS_SUCCESS;

303: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
304:
305:
306: -- Initialize API return status to SUCCESS
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308:
309: --
310: -- API body
311: --

Line 329: P_Init_Msg_List => FND_API.G_FALSE,

325: -- Calling Private package: Create_Requirement_Lines
326: -- Hint: Primary key needs to be returned
327: CSP_REQUIREMENT_LINES_PVT.Create_REQUIREMENT_LINES(
328: P_Api_Version_Number => 1.0,
329: P_Init_Msg_List => FND_API.G_FALSE,
330: P_Commit => FND_API.G_FALSE,
331: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
332: P_REQUIREMENT_LINE_Tbl => l_pvt_RQL_Tbl ,
333: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 330: P_Commit => FND_API.G_FALSE,

326: -- Hint: Primary key needs to be returned
327: CSP_REQUIREMENT_LINES_PVT.Create_REQUIREMENT_LINES(
328: P_Api_Version_Number => 1.0,
329: P_Init_Msg_List => FND_API.G_FALSE,
330: P_Commit => FND_API.G_FALSE,
331: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
332: P_REQUIREMENT_LINE_Tbl => l_pvt_RQL_Tbl ,
333: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
334: X_REQUIREMENT_LINE_TBL => l_pvt_RQL_tbl1,

Line 331: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

327: CSP_REQUIREMENT_LINES_PVT.Create_REQUIREMENT_LINES(
328: P_Api_Version_Number => 1.0,
329: P_Init_Msg_List => FND_API.G_FALSE,
330: P_Commit => FND_API.G_FALSE,
331: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
332: P_REQUIREMENT_LINE_Tbl => l_pvt_RQL_Tbl ,
333: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
334: X_REQUIREMENT_LINE_TBL => l_pvt_RQL_tbl1,
335: X_Return_Status => x_return_status,

Line 340: IF x_return_status = FND_API.G_RET_STS_ERROR then

336: X_Msg_Count => x_msg_count,
337: X_Msg_Data => x_msg_data);
338:
339: -- Check return status from the above procedure call
340: IF x_return_status = FND_API.G_RET_STS_ERROR then
341: raise FND_API.G_EXC_ERROR;
342: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
343: raise FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;

Line 341: raise FND_API.G_EXC_ERROR;

337: X_Msg_Data => x_msg_data);
338:
339: -- Check return status from the above procedure call
340: IF x_return_status = FND_API.G_RET_STS_ERROR then
341: raise FND_API.G_EXC_ERROR;
342: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
343: raise FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:

Line 342: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

338:
339: -- Check return status from the above procedure call
340: IF x_return_status = FND_API.G_RET_STS_ERROR then
341: raise FND_API.G_EXC_ERROR;
342: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
343: raise FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: FOR I IN 1..l_pvt_rql_tbl.COUNT LOOP

Line 343: raise FND_API.G_EXC_UNEXPECTED_ERROR;

339: -- Check return status from the above procedure call
340: IF x_return_status = FND_API.G_RET_STS_ERROR then
341: raise FND_API.G_EXC_ERROR;
342: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
343: raise FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: FOR I IN 1..l_pvt_rql_tbl.COUNT LOOP
347: x_requirement_line_tbl(I).REQUIREMENT_LINE_ID := l_pvt_Rql_tbl(I).REQUIREMENT_LINE_ID;

Line 391: IF FND_API.to_Boolean( p_commit )

387: --
388: -- End of API body.
389: --
390: -- Standard check for p_commit
391: IF FND_API.to_Boolean( p_commit )
392: THEN
393: COMMIT WORK;
394: END IF;
395:

Line 408: WHEN FND_API.G_EXC_ERROR THEN

404: p_data => x_msg_data
405: );
406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
410: P_API_NAME => L_API_NAME
411: ,P_PKG_NAME => G_PKG_NAME
412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

414: ,X_MSG_COUNT => X_MSG_COUNT
415: ,X_MSG_DATA => X_MSG_DATA
416: ,X_RETURN_STATUS => X_RETURN_STATUS);
417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
420: P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 443: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

439:
440: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
441: PROCEDURE Update_REQUIREMENT_LINES(
442: P_Api_Version_Number IN NUMBER,
443: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
444: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
445: P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_TBL,
446: X_Return_Status OUT NOCOPY VARCHAR2,
447: X_Msg_Count OUT NOCOPY NUMBER,

Line 444: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

440: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
441: PROCEDURE Update_REQUIREMENT_LINES(
442: P_Api_Version_Number IN NUMBER,
443: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
444: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
445: P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_TBL,
446: X_Return_Status OUT NOCOPY VARCHAR2,
447: X_Msg_Count OUT NOCOPY NUMBER,
448: X_Msg_Data OUT NOCOPY VARCHAR2

Line 461: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

457: -- Standard Start of API savepoint
458: SAVEPOINT UPDATE_Packlist_Headers_PUB;
459:
460: -- Standard call to check for call compatibility.
461: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
462: p_api_version_number,
463: l_api_name,
464: G_PKG_NAME)
465: THEN

Line 466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

462: p_api_version_number,
463: l_api_name,
464: G_PKG_NAME)
465: THEN
466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
467: END IF;
468:
469:
470: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 471: IF FND_API.to_Boolean( p_init_msg_list )

467: END IF;
468:
469:
470: -- Initialize message list if p_init_msg_list is set to TRUE.
471: IF FND_API.to_Boolean( p_init_msg_list )
472: THEN
473: FND_MSG_PUB.initialize;
474: END IF;
475:

Line 482: x_return_status := FND_API.G_RET_STS_SUCCESS;

478: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
479:
480:
481: -- Initialize API return status to SUCCESS
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483:
484: --
485: -- API body
486: --

Line 502: P_Init_Msg_List => FND_API.G_FALSE,

498: Validate_Requirement_Lines(l_pvt_RQL_Tbl);
499:
500: CSP_REQUIREMENT_LINES_PVT.Update_REQUIREMENT_LINES(
501: P_Api_Version_Number => 1.0,
502: P_Init_Msg_List => FND_API.G_FALSE,
503: P_Commit => p_commit,
504: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
505: P_Requirement_Line_Tbl => l_pvt_RQL_Tbl ,
506: X_Return_Status => x_return_status,

Line 504: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

500: CSP_REQUIREMENT_LINES_PVT.Update_REQUIREMENT_LINES(
501: P_Api_Version_Number => 1.0,
502: P_Init_Msg_List => FND_API.G_FALSE,
503: P_Commit => p_commit,
504: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
505: P_Requirement_Line_Tbl => l_pvt_RQL_Tbl ,
506: X_Return_Status => x_return_status,
507: X_Msg_Count => x_msg_count,
508: X_Msg_Data => x_msg_data);

Line 513: IF x_return_status = FND_API.G_RET_STS_ERROR then

509:
510:
511:
512: -- Check return status from the above procedure call
513: IF x_return_status = FND_API.G_RET_STS_ERROR then
514: raise FND_API.G_EXC_ERROR;
515: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
516: raise FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;

Line 514: raise FND_API.G_EXC_ERROR;

510:
511:
512: -- Check return status from the above procedure call
513: IF x_return_status = FND_API.G_RET_STS_ERROR then
514: raise FND_API.G_EXC_ERROR;
515: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
516: raise FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:

Line 515: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

511:
512: -- Check return status from the above procedure call
513: IF x_return_status = FND_API.G_RET_STS_ERROR then
514: raise FND_API.G_EXC_ERROR;
515: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
516: raise FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: --

Line 516: raise FND_API.G_EXC_UNEXPECTED_ERROR;

512: -- Check return status from the above procedure call
513: IF x_return_status = FND_API.G_RET_STS_ERROR then
514: raise FND_API.G_EXC_ERROR;
515: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
516: raise FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: --
520: -- End of API body

Line 524: IF FND_API.to_Boolean( p_commit )

520: -- End of API body
521: --
522:
523: -- Standard check for p_commit
524: IF FND_API.to_Boolean( p_commit )
525: THEN
526: COMMIT WORK;
527: END IF;
528:

Line 541: WHEN FND_API.G_EXC_ERROR THEN

537: p_data => x_msg_data
538: );
539:
540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN
542: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
543: P_API_NAME => L_API_NAME
544: ,P_PKG_NAME => G_PKG_NAME
545: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

547: ,X_MSG_COUNT => X_MSG_COUNT
548: ,X_MSG_DATA => X_MSG_DATA
549: ,X_RETURN_STATUS => X_RETURN_STATUS);
550:
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
553: P_API_NAME => L_API_NAME
554: ,P_PKG_NAME => G_PKG_NAME
555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 577: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

573: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
574: -- The Master delete procedure may not be needed depends on different business requirements.
575: PROCEDURE Delete_REQUIREMENT_LINES(
576: P_Api_Version_Number IN NUMBER,
577: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
578: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
579: P_RQL_Tbl IN RQL_Tbl_Type,
580: X_Return_Status OUT NOCOPY VARCHAR2,
581: X_Msg_Count OUT NOCOPY NUMBER,

Line 578: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

574: -- The Master delete procedure may not be needed depends on different business requirements.
575: PROCEDURE Delete_REQUIREMENT_LINES(
576: P_Api_Version_Number IN NUMBER,
577: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
578: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
579: P_RQL_Tbl IN RQL_Tbl_Type,
580: X_Return_Status OUT NOCOPY VARCHAR2,
581: X_Msg_Count OUT NOCOPY NUMBER,
582: X_Msg_Data OUT NOCOPY VARCHAR2

Line 597: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

593: -- Standard Start of API savepoint
594: SAVEPOINT DELETE_REQUIREMENT_LINES_PUB;
595:
596: -- Standard call to check for call compatibility.
597: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
598: p_api_version_number,
599: l_api_name,
600: G_PKG_NAME)
601: THEN

Line 602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

598: p_api_version_number,
599: l_api_name,
600: G_PKG_NAME)
601: THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 607: IF FND_API.to_Boolean( p_init_msg_list )

603: END IF;
604:
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.to_Boolean( p_init_msg_list )
608: THEN
609: FND_MSG_PUB.initialize;
610: END IF;
611:

Line 618: x_return_status := FND_API.G_RET_STS_SUCCESS;

614: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
615:
616:
617: -- Initialize API return status to SUCCESS
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619:
620: --
621: -- API body
622: --

Line 655: P_Init_Msg_List => FND_API.G_FALSE,

651: END LOOP;
652:
653: CSP_REQUIREMENT_LINES_PVT.Delete_REQUIREMENT_LINES(
654: P_Api_Version_Number => 1.0,
655: P_Init_Msg_List => FND_API.G_FALSE,
656: P_Commit => p_commit,
657: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
658: P_Requirement_Line_Tbl => l_pvt_RQL_Tbl,
659: X_Return_Status => x_return_status,

Line 657: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

653: CSP_REQUIREMENT_LINES_PVT.Delete_REQUIREMENT_LINES(
654: P_Api_Version_Number => 1.0,
655: P_Init_Msg_List => FND_API.G_FALSE,
656: P_Commit => p_commit,
657: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
658: P_Requirement_Line_Tbl => l_pvt_RQL_Tbl,
659: X_Return_Status => x_return_status,
660: X_Msg_Count => x_msg_count,
661: X_Msg_Data => x_msg_data);

Line 666: IF x_return_status = FND_API.G_RET_STS_ERROR then

662:
663:
664:
665: -- Check return status from the above procedure call
666: IF x_return_status = FND_API.G_RET_STS_ERROR then
667: raise FND_API.G_EXC_ERROR;
668: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
669: raise FND_API.G_EXC_UNEXPECTED_ERROR;
670: END IF;

Line 667: raise FND_API.G_EXC_ERROR;

663:
664:
665: -- Check return status from the above procedure call
666: IF x_return_status = FND_API.G_RET_STS_ERROR then
667: raise FND_API.G_EXC_ERROR;
668: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
669: raise FND_API.G_EXC_UNEXPECTED_ERROR;
670: END IF;
671:

Line 668: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

664:
665: -- Check return status from the above procedure call
666: IF x_return_status = FND_API.G_RET_STS_ERROR then
667: raise FND_API.G_EXC_ERROR;
668: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
669: raise FND_API.G_EXC_UNEXPECTED_ERROR;
670: END IF;
671:
672: --

Line 669: raise FND_API.G_EXC_UNEXPECTED_ERROR;

665: -- Check return status from the above procedure call
666: IF x_return_status = FND_API.G_RET_STS_ERROR then
667: raise FND_API.G_EXC_ERROR;
668: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
669: raise FND_API.G_EXC_UNEXPECTED_ERROR;
670: END IF;
671:
672: --
673: -- End of API body

Line 677: IF FND_API.to_Boolean( p_commit )

673: -- End of API body
674: --
675:
676: -- Standard check for p_commit
677: IF FND_API.to_Boolean( p_commit )
678: THEN
679: COMMIT WORK;
680: END IF;
681:

Line 694: WHEN FND_API.G_EXC_ERROR THEN

690: p_data => x_msg_data
691: );
692:
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
696: P_API_NAME => L_API_NAME
697: ,P_PKG_NAME => G_PKG_NAME
698: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

700: ,X_MSG_COUNT => X_MSG_COUNT
701: ,X_MSG_DATA => X_MSG_DATA
702: ,X_RETURN_STATUS => X_RETURN_STATUS);
703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
706: P_API_NAME => L_API_NAME
707: ,P_PKG_NAME => G_PKG_NAME
708: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR