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.

APPS.OE_ORDER_IMPORT_UTIL_PVT dependencies on FND_API

Line 39: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

35:
36: DELETE FROM oe_actions_interface
37: WHERE order_source_id = p_order_source_id
38: AND orig_sys_document_ref = p_orig_sys_document_ref
39: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
40: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
41: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
42: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
43: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 40: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

36: DELETE FROM oe_actions_interface
37: WHERE order_source_id = p_order_source_id
38: AND orig_sys_document_ref = p_orig_sys_document_ref
39: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
40: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
41: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
42: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
43: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
44: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 41: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

37: WHERE order_source_id = p_order_source_id
38: AND orig_sys_document_ref = p_orig_sys_document_ref
39: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
40: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
41: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
42: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
43: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
44: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
45: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 42: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

38: AND orig_sys_document_ref = p_orig_sys_document_ref
39: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
40: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
41: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
42: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
43: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
44: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
45: AND nvl( request_id, FND_API.G_MISS_NUM)
46: = nvl(p_request_id, FND_API.G_MISS_NUM);

Line 43: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

39: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
40: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
41: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
42: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
43: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
44: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
45: AND nvl( request_id, FND_API.G_MISS_NUM)
46: = nvl(p_request_id, FND_API.G_MISS_NUM);
47:

Line 44: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

40: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
41: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
42: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
43: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
44: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
45: AND nvl( request_id, FND_API.G_MISS_NUM)
46: = nvl(p_request_id, FND_API.G_MISS_NUM);
47:
48: DELETE FROM oe_reservtns_interface

Line 45: AND nvl( request_id, FND_API.G_MISS_NUM)

41: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
42: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
43: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
44: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
45: AND nvl( request_id, FND_API.G_MISS_NUM)
46: = nvl(p_request_id, FND_API.G_MISS_NUM);
47:
48: DELETE FROM oe_reservtns_interface
49: WHERE order_source_id = p_order_source_id

Line 46: = nvl(p_request_id, FND_API.G_MISS_NUM);

42: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
43: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
44: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
45: AND nvl( request_id, FND_API.G_MISS_NUM)
46: = nvl(p_request_id, FND_API.G_MISS_NUM);
47:
48: DELETE FROM oe_reservtns_interface
49: WHERE order_source_id = p_order_source_id
50: AND orig_sys_document_ref = p_orig_sys_document_ref

Line 51: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

47:
48: DELETE FROM oe_reservtns_interface
49: WHERE order_source_id = p_order_source_id
50: AND orig_sys_document_ref = p_orig_sys_document_ref
51: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
52: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
53: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
54: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
55: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 52: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

48: DELETE FROM oe_reservtns_interface
49: WHERE order_source_id = p_order_source_id
50: AND orig_sys_document_ref = p_orig_sys_document_ref
51: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
52: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
53: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
54: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
55: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
56: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 53: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

49: WHERE order_source_id = p_order_source_id
50: AND orig_sys_document_ref = p_orig_sys_document_ref
51: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
52: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
53: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
54: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
55: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
56: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
57: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 54: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

50: AND orig_sys_document_ref = p_orig_sys_document_ref
51: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
52: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
53: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
54: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
55: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
56: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
57: AND nvl( request_id, FND_API.G_MISS_NUM)
58: = nvl(p_request_id, FND_API.G_MISS_NUM);

Line 55: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

51: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
52: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
53: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
54: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
55: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
56: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
57: AND nvl( request_id, FND_API.G_MISS_NUM)
58: = nvl(p_request_id, FND_API.G_MISS_NUM);
59:

Line 56: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

52: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
53: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
54: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
55: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
56: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
57: AND nvl( request_id, FND_API.G_MISS_NUM)
58: = nvl(p_request_id, FND_API.G_MISS_NUM);
59:
60: DELETE FROM oe_lotserials_interface

Line 57: AND nvl( request_id, FND_API.G_MISS_NUM)

53: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
54: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
55: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
56: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
57: AND nvl( request_id, FND_API.G_MISS_NUM)
58: = nvl(p_request_id, FND_API.G_MISS_NUM);
59:
60: DELETE FROM oe_lotserials_interface
61: WHERE order_source_id = p_order_source_id

Line 58: = nvl(p_request_id, FND_API.G_MISS_NUM);

54: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
55: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
56: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
57: AND nvl( request_id, FND_API.G_MISS_NUM)
58: = nvl(p_request_id, FND_API.G_MISS_NUM);
59:
60: DELETE FROM oe_lotserials_interface
61: WHERE order_source_id = p_order_source_id
62: AND orig_sys_document_ref = p_orig_sys_document_ref

Line 63: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

59:
60: DELETE FROM oe_lotserials_interface
61: WHERE order_source_id = p_order_source_id
62: AND orig_sys_document_ref = p_orig_sys_document_ref
63: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
64: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
65: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
66: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
67: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 64: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

60: DELETE FROM oe_lotserials_interface
61: WHERE order_source_id = p_order_source_id
62: AND orig_sys_document_ref = p_orig_sys_document_ref
63: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
64: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
65: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
66: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
67: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
68: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 65: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

61: WHERE order_source_id = p_order_source_id
62: AND orig_sys_document_ref = p_orig_sys_document_ref
63: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
64: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
65: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
66: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
67: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
68: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
69: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 66: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

62: AND orig_sys_document_ref = p_orig_sys_document_ref
63: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
64: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
65: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
66: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
67: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
68: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
69: AND nvl( request_id, FND_API.G_MISS_NUM)
70: = nvl(p_request_id, FND_API.G_MISS_NUM);

Line 67: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

63: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
64: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
65: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
66: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
67: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
68: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
69: AND nvl( request_id, FND_API.G_MISS_NUM)
70: = nvl(p_request_id, FND_API.G_MISS_NUM);
71:

Line 68: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

64: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
65: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
66: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
67: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
68: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
69: AND nvl( request_id, FND_API.G_MISS_NUM)
70: = nvl(p_request_id, FND_API.G_MISS_NUM);
71:
72: DELETE FROM oe_credits_interface

Line 69: AND nvl( request_id, FND_API.G_MISS_NUM)

65: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
66: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
67: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
68: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
69: AND nvl( request_id, FND_API.G_MISS_NUM)
70: = nvl(p_request_id, FND_API.G_MISS_NUM);
71:
72: DELETE FROM oe_credits_interface
73: WHERE order_source_id = p_order_source_id

Line 70: = nvl(p_request_id, FND_API.G_MISS_NUM);

66: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
67: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
68: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
69: AND nvl( request_id, FND_API.G_MISS_NUM)
70: = nvl(p_request_id, FND_API.G_MISS_NUM);
71:
72: DELETE FROM oe_credits_interface
73: WHERE order_source_id = p_order_source_id
74: AND orig_sys_document_ref = p_orig_sys_document_ref

Line 75: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

71:
72: DELETE FROM oe_credits_interface
73: WHERE order_source_id = p_order_source_id
74: AND orig_sys_document_ref = p_orig_sys_document_ref
75: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
76: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
77: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
78: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
79: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 76: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

72: DELETE FROM oe_credits_interface
73: WHERE order_source_id = p_order_source_id
74: AND orig_sys_document_ref = p_orig_sys_document_ref
75: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
76: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
77: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
78: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
79: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
80: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 77: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

73: WHERE order_source_id = p_order_source_id
74: AND orig_sys_document_ref = p_orig_sys_document_ref
75: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
76: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
77: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
78: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
79: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
80: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
81: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 78: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

74: AND orig_sys_document_ref = p_orig_sys_document_ref
75: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
76: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
77: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
78: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
79: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
80: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
81: AND nvl( request_id, FND_API.G_MISS_NUM)
82: = nvl(p_request_id, FND_API.G_MISS_NUM);

Line 79: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

75: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
76: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
77: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
78: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
79: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
80: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
81: AND nvl( request_id, FND_API.G_MISS_NUM)
82: = nvl(p_request_id, FND_API.G_MISS_NUM);
83:

Line 80: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

76: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
77: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
78: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
79: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
80: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
81: AND nvl( request_id, FND_API.G_MISS_NUM)
82: = nvl(p_request_id, FND_API.G_MISS_NUM);
83:
84: DELETE FROM oe_payments_interface

Line 81: AND nvl( request_id, FND_API.G_MISS_NUM)

77: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
78: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
79: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
80: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
81: AND nvl( request_id, FND_API.G_MISS_NUM)
82: = nvl(p_request_id, FND_API.G_MISS_NUM);
83:
84: DELETE FROM oe_payments_interface
85: WHERE order_source_id = p_order_source_id

Line 82: = nvl(p_request_id, FND_API.G_MISS_NUM);

78: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
79: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
80: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
81: AND nvl( request_id, FND_API.G_MISS_NUM)
82: = nvl(p_request_id, FND_API.G_MISS_NUM);
83:
84: DELETE FROM oe_payments_interface
85: WHERE order_source_id = p_order_source_id
86: AND orig_sys_document_ref = p_orig_sys_document_ref

Line 87: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

83:
84: DELETE FROM oe_payments_interface
85: WHERE order_source_id = p_order_source_id
86: AND orig_sys_document_ref = p_orig_sys_document_ref
87: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
88: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
89: AND nvl( request_id, FND_API.G_MISS_NUM)
90: = nvl(p_request_id, FND_API.G_MISS_NUM);
91:

Line 88: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

84: DELETE FROM oe_payments_interface
85: WHERE order_source_id = p_order_source_id
86: AND orig_sys_document_ref = p_orig_sys_document_ref
87: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
88: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
89: AND nvl( request_id, FND_API.G_MISS_NUM)
90: = nvl(p_request_id, FND_API.G_MISS_NUM);
91:
92: DELETE FROM oe_price_adjs_interface

Line 89: AND nvl( request_id, FND_API.G_MISS_NUM)

85: WHERE order_source_id = p_order_source_id
86: AND orig_sys_document_ref = p_orig_sys_document_ref
87: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
88: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
89: AND nvl( request_id, FND_API.G_MISS_NUM)
90: = nvl(p_request_id, FND_API.G_MISS_NUM);
91:
92: DELETE FROM oe_price_adjs_interface
93: WHERE order_source_id = p_order_source_id

Line 90: = nvl(p_request_id, FND_API.G_MISS_NUM);

86: AND orig_sys_document_ref = p_orig_sys_document_ref
87: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
88: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
89: AND nvl( request_id, FND_API.G_MISS_NUM)
90: = nvl(p_request_id, FND_API.G_MISS_NUM);
91:
92: DELETE FROM oe_price_adjs_interface
93: WHERE order_source_id = p_order_source_id
94: AND orig_sys_document_ref = p_orig_sys_document_ref

Line 95: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

91:
92: DELETE FROM oe_price_adjs_interface
93: WHERE order_source_id = p_order_source_id
94: AND orig_sys_document_ref = p_orig_sys_document_ref
95: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
96: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
97: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
98: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
99: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 96: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

92: DELETE FROM oe_price_adjs_interface
93: WHERE order_source_id = p_order_source_id
94: AND orig_sys_document_ref = p_orig_sys_document_ref
95: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
96: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
97: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
98: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
99: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
100: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 97: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

93: WHERE order_source_id = p_order_source_id
94: AND orig_sys_document_ref = p_orig_sys_document_ref
95: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
96: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
97: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
98: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
99: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
100: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
101: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 98: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

94: AND orig_sys_document_ref = p_orig_sys_document_ref
95: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
96: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
97: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
98: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
99: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
100: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
101: AND nvl( request_id, FND_API.G_MISS_NUM)
102: = nvl(p_request_id, FND_API.G_MISS_NUM);

Line 99: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

95: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
96: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
97: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
98: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
99: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
100: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
101: AND nvl( request_id, FND_API.G_MISS_NUM)
102: = nvl(p_request_id, FND_API.G_MISS_NUM);
103: /* 1433292 */

Line 100: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

96: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
97: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
98: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
99: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
100: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
101: AND nvl( request_id, FND_API.G_MISS_NUM)
102: = nvl(p_request_id, FND_API.G_MISS_NUM);
103: /* 1433292 */
104: DELETE FROM oe_price_atts_interface

Line 101: AND nvl( request_id, FND_API.G_MISS_NUM)

97: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
98: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
99: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
100: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
101: AND nvl( request_id, FND_API.G_MISS_NUM)
102: = nvl(p_request_id, FND_API.G_MISS_NUM);
103: /* 1433292 */
104: DELETE FROM oe_price_atts_interface
105: WHERE order_source_id = p_order_source_id

Line 102: = nvl(p_request_id, FND_API.G_MISS_NUM);

98: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
99: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
100: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
101: AND nvl( request_id, FND_API.G_MISS_NUM)
102: = nvl(p_request_id, FND_API.G_MISS_NUM);
103: /* 1433292 */
104: DELETE FROM oe_price_atts_interface
105: WHERE order_source_id = p_order_source_id
106: AND orig_sys_document_ref = p_orig_sys_document_ref

Line 107: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

103: /* 1433292 */
104: DELETE FROM oe_price_atts_interface
105: WHERE order_source_id = p_order_source_id
106: AND orig_sys_document_ref = p_orig_sys_document_ref
107: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
108: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
109: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
110: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
111: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 108: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

104: DELETE FROM oe_price_atts_interface
105: WHERE order_source_id = p_order_source_id
106: AND orig_sys_document_ref = p_orig_sys_document_ref
107: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
108: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
109: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
110: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
111: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
112: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 109: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

105: WHERE order_source_id = p_order_source_id
106: AND orig_sys_document_ref = p_orig_sys_document_ref
107: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
108: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
109: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
110: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
111: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
112: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
113: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 110: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

106: AND orig_sys_document_ref = p_orig_sys_document_ref
107: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
108: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
109: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
110: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
111: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
112: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
113: AND nvl( request_id, FND_API.G_MISS_NUM)
114: = nvl(p_request_id, FND_API.G_MISS_NUM);

Line 111: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

107: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
108: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
109: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
110: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
111: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
112: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
113: AND nvl( request_id, FND_API.G_MISS_NUM)
114: = nvl(p_request_id, FND_API.G_MISS_NUM);
115:

Line 112: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

108: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
109: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
110: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
111: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
112: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
113: AND nvl( request_id, FND_API.G_MISS_NUM)
114: = nvl(p_request_id, FND_API.G_MISS_NUM);
115:
116: -- { Following changes are made to fix the bug 2922709

Line 113: AND nvl( request_id, FND_API.G_MISS_NUM)

109: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
110: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
111: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
112: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
113: AND nvl( request_id, FND_API.G_MISS_NUM)
114: = nvl(p_request_id, FND_API.G_MISS_NUM);
115:
116: -- { Following changes are made to fix the bug 2922709
117: -- The issue is that the acknowledgment are not being send for the

Line 114: = nvl(p_request_id, FND_API.G_MISS_NUM);

110: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
111: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
112: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
113: AND nvl( request_id, FND_API.G_MISS_NUM)
114: = nvl(p_request_id, FND_API.G_MISS_NUM);
115:
116: -- { Following changes are made to fix the bug 2922709
117: -- The issue is that the acknowledgment are not being send for the
118: -- Rejected Order and Line.

Line 133: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

129: INTO l_exists_reject_line
130: FROM oe_lines_interface
131: WHERE order_source_id = p_order_source_id
132: AND orig_sys_document_ref = p_orig_sys_document_ref
133: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
134: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
135: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
136: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
137: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 134: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

130: FROM oe_lines_interface
131: WHERE order_source_id = p_order_source_id
132: AND orig_sys_document_ref = p_orig_sys_document_ref
133: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
134: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
135: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
136: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
137: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
138: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 135: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

131: WHERE order_source_id = p_order_source_id
132: AND orig_sys_document_ref = p_orig_sys_document_ref
133: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
134: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
135: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
136: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
137: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
138: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
139: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 136: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

132: AND orig_sys_document_ref = p_orig_sys_document_ref
133: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
134: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
135: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
136: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
137: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
138: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
139: AND nvl( request_id, FND_API.G_MISS_NUM)
140: = nvl(p_request_id, FND_API.G_MISS_NUM)

Line 137: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

133: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
134: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
135: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
136: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
137: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
138: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
139: AND nvl( request_id, FND_API.G_MISS_NUM)
140: = nvl(p_request_id, FND_API.G_MISS_NUM)
141: AND nvl(rejected_flag,'N')= 'Y'

Line 138: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

134: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
135: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
136: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
137: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
138: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
139: AND nvl( request_id, FND_API.G_MISS_NUM)
140: = nvl(p_request_id, FND_API.G_MISS_NUM)
141: AND nvl(rejected_flag,'N')= 'Y'
142: AND rownum = 1;

Line 139: AND nvl( request_id, FND_API.G_MISS_NUM)

135: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
136: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
137: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
138: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
139: AND nvl( request_id, FND_API.G_MISS_NUM)
140: = nvl(p_request_id, FND_API.G_MISS_NUM)
141: AND nvl(rejected_flag,'N')= 'Y'
142: AND rownum = 1;
143:

Line 140: = nvl(p_request_id, FND_API.G_MISS_NUM)

136: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
137: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
138: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
139: AND nvl( request_id, FND_API.G_MISS_NUM)
140: = nvl(p_request_id, FND_API.G_MISS_NUM)
141: AND nvl(rejected_flag,'N')= 'Y'
142: AND rownum = 1;
143:
144: DELETE FROM oe_lines_interface

Line 147: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

143:
144: DELETE FROM oe_lines_interface
145: WHERE order_source_id = p_order_source_id
146: AND orig_sys_document_ref = p_orig_sys_document_ref
147: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
148: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
149: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
150: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
151: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 148: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

144: DELETE FROM oe_lines_interface
145: WHERE order_source_id = p_order_source_id
146: AND orig_sys_document_ref = p_orig_sys_document_ref
147: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
148: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
149: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
150: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
151: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
152: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 149: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

145: WHERE order_source_id = p_order_source_id
146: AND orig_sys_document_ref = p_orig_sys_document_ref
147: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
148: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
149: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
150: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
151: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
152: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
153: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 150: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

146: AND orig_sys_document_ref = p_orig_sys_document_ref
147: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
148: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
149: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
150: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
151: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
152: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
153: AND nvl( request_id, FND_API.G_MISS_NUM)
154: = nvl(p_request_id, FND_API.G_MISS_NUM)

Line 151: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

147: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
148: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
149: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
150: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
151: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
152: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
153: AND nvl( request_id, FND_API.G_MISS_NUM)
154: = nvl(p_request_id, FND_API.G_MISS_NUM)
155: AND nvl(rejected_flag,'N')= 'N';

Line 152: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

148: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
149: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
150: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
151: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
152: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
153: AND nvl( request_id, FND_API.G_MISS_NUM)
154: = nvl(p_request_id, FND_API.G_MISS_NUM)
155: AND nvl(rejected_flag,'N')= 'N';
156: EXCEPTION

Line 153: AND nvl( request_id, FND_API.G_MISS_NUM)

149: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
150: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
151: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
152: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
153: AND nvl( request_id, FND_API.G_MISS_NUM)
154: = nvl(p_request_id, FND_API.G_MISS_NUM)
155: AND nvl(rejected_flag,'N')= 'N';
156: EXCEPTION
157: When NO_DATA_FOUND Then

Line 154: = nvl(p_request_id, FND_API.G_MISS_NUM)

150: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
151: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
152: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
153: AND nvl( request_id, FND_API.G_MISS_NUM)
154: = nvl(p_request_id, FND_API.G_MISS_NUM)
155: AND nvl(rejected_flag,'N')= 'N';
156: EXCEPTION
157: When NO_DATA_FOUND Then
158:

Line 167: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

163:
164: DELETE FROM oe_lines_interface
165: WHERE order_source_id = p_order_source_id
166: AND orig_sys_document_ref = p_orig_sys_document_ref
167: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
168: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
169: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
170: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
171: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 168: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

164: DELETE FROM oe_lines_interface
165: WHERE order_source_id = p_order_source_id
166: AND orig_sys_document_ref = p_orig_sys_document_ref
167: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
168: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
169: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
170: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
171: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
172: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 169: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

165: WHERE order_source_id = p_order_source_id
166: AND orig_sys_document_ref = p_orig_sys_document_ref
167: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
168: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
169: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
170: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
171: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
172: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
173: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 170: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

166: AND orig_sys_document_ref = p_orig_sys_document_ref
167: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
168: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
169: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
170: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
171: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
172: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
173: AND nvl( request_id, FND_API.G_MISS_NUM)
174: = nvl(p_request_id, FND_API.G_MISS_NUM);

Line 171: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

167: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
168: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
169: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
170: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
171: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
172: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
173: AND nvl( request_id, FND_API.G_MISS_NUM)
174: = nvl(p_request_id, FND_API.G_MISS_NUM);
175:

Line 172: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

168: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
169: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
170: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
171: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
172: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
173: AND nvl( request_id, FND_API.G_MISS_NUM)
174: = nvl(p_request_id, FND_API.G_MISS_NUM);
175:
176: DELETE FROM oe_headers_interface

Line 173: AND nvl( request_id, FND_API.G_MISS_NUM)

169: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
170: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
171: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
172: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
173: AND nvl( request_id, FND_API.G_MISS_NUM)
174: = nvl(p_request_id, FND_API.G_MISS_NUM);
175:
176: DELETE FROM oe_headers_interface
177: WHERE order_source_id = p_order_source_id

Line 174: = nvl(p_request_id, FND_API.G_MISS_NUM);

170: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
171: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
172: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
173: AND nvl( request_id, FND_API.G_MISS_NUM)
174: = nvl(p_request_id, FND_API.G_MISS_NUM);
175:
176: DELETE FROM oe_headers_interface
177: WHERE order_source_id = p_order_source_id
178: AND orig_sys_document_ref = p_orig_sys_document_ref

Line 179: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)

175:
176: DELETE FROM oe_headers_interface
177: WHERE order_source_id = p_order_source_id
178: AND orig_sys_document_ref = p_orig_sys_document_ref
179: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
180: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
181: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
182: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
183: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

Line 180: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

176: DELETE FROM oe_headers_interface
177: WHERE order_source_id = p_order_source_id
178: AND orig_sys_document_ref = p_orig_sys_document_ref
179: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
180: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
181: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
182: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
183: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
184: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

Line 181: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)

177: WHERE order_source_id = p_order_source_id
178: AND orig_sys_document_ref = p_orig_sys_document_ref
179: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
180: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
181: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
182: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
183: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
184: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
185: AND nvl( request_id, FND_API.G_MISS_NUM)

Line 182: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

178: AND orig_sys_document_ref = p_orig_sys_document_ref
179: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
180: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
181: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
182: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
183: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
184: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
185: AND nvl( request_id, FND_API.G_MISS_NUM)
186: = nvl(p_request_id, FND_API.G_MISS_NUM);

Line 183: AND nvl( change_sequence,FND_API.G_MISS_CHAR)

179: AND nvl( sold_to_org_id, FND_API.G_MISS_NUM)
180: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
181: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
182: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
183: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
184: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
185: AND nvl( request_id, FND_API.G_MISS_NUM)
186: = nvl(p_request_id, FND_API.G_MISS_NUM);
187:

Line 184: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)

180: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
181: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
182: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
183: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
184: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
185: AND nvl( request_id, FND_API.G_MISS_NUM)
186: = nvl(p_request_id, FND_API.G_MISS_NUM);
187:
188:

Line 185: AND nvl( request_id, FND_API.G_MISS_NUM)

181: AND nvl( sold_to_org, FND_API.G_MISS_CHAR)
182: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
183: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
184: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
185: AND nvl( request_id, FND_API.G_MISS_NUM)
186: = nvl(p_request_id, FND_API.G_MISS_NUM);
187:
188:
189: END;

Line 186: = nvl(p_request_id, FND_API.G_MISS_NUM);

182: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
183: AND nvl( change_sequence,FND_API.G_MISS_CHAR)
184: = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
185: AND nvl( request_id, FND_API.G_MISS_NUM)
186: = nvl(p_request_id, FND_API.G_MISS_NUM);
187:
188:
189: END;
190:

Line 193: p_return_status := FND_API.G_RET_STS_SUCCESS;

189: END;
190:
191: -- End of fix the bug 2922709}
192:
193: p_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195:
196: EXCEPTION
197: WHEN OTHERS THEN

Line 201: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

197: WHEN OTHERS THEN
198: oe_debug_pub.add('Unexpected error: '||sqlerrm);
199:
200: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
201: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Delete_Order',substr(sqlerrm,1,2000));
203: END IF;
204:
205: END Delete_Order;

Line 238: AND nvl( change_sequence, FND_API.G_MISS_CHAR)

234:
235: /*DELETE FROM OE_PROCESSING_MSGS_VL
236: WHERE order_source_id = p_order_source_id
237: AND original_sys_document_ref = p_orig_sys_document_ref
238: AND nvl( change_sequence, FND_API.G_MISS_CHAR)
239: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);*/
240:
241:
242: --Call to DELETE_OI_MESSAGE to delete the messages from oe_processing_msgs

Line 239: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);*/

235: /*DELETE FROM OE_PROCESSING_MSGS_VL
236: WHERE order_source_id = p_order_source_id
237: AND original_sys_document_ref = p_orig_sys_document_ref
238: AND nvl( change_sequence, FND_API.G_MISS_CHAR)
239: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);*/
240:
241:
242: --Call to DELETE_OI_MESSAGE to delete the messages from oe_processing_msgs
243: --and oe_processing_msgs_tl.Fix for bug#2110646.

Line 253: p_return_status := FND_API.G_RET_STS_SUCCESS;

249: );
250:
251:
252:
253: p_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: EXCEPTION
256: WHEN OTHERS THEN
257: oe_debug_pub.add('Unexpected error: '||sqlerrm);

Line 260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

256: WHEN OTHERS THEN
257: oe_debug_pub.add('Unexpected error: '||sqlerrm);
258:
259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Delete_Messages');
262: END IF;
263:
264: END Delete_Messages;