APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on FND_API

Line 21: delete_source_cart VARCHAR2(1) := FND_API.G_true ,

17: /*New saveshare control record type which includes ASO control record*/
18: TYPE SAVESHARE_CONTROL_REC_TYPE is record(
19: control_rec ASO_QUOTE_PUB.control_rec_type
20: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
21: delete_source_cart VARCHAR2(1) := FND_API.G_true ,
22: combinesameitem VARCHAR2(1) := FND_API.G_true ,
23: operation_code NUMBER ,
24: deactivate_cart VARCHAR2(1) := FND_API.G_false );
25:

Line 22: combinesameitem VARCHAR2(1) := FND_API.G_true ,

18: TYPE SAVESHARE_CONTROL_REC_TYPE is record(
19: control_rec ASO_QUOTE_PUB.control_rec_type
20: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
21: delete_source_cart VARCHAR2(1) := FND_API.G_true ,
22: combinesameitem VARCHAR2(1) := FND_API.G_true ,
23: operation_code NUMBER ,
24: deactivate_cart VARCHAR2(1) := FND_API.G_false );
25:
26:

Line 24: deactivate_cart VARCHAR2(1) := FND_API.G_false );

20: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
21: delete_source_cart VARCHAR2(1) := FND_API.G_true ,
22: combinesameitem VARCHAR2(1) := FND_API.G_true ,
23: operation_code NUMBER ,
24: deactivate_cart VARCHAR2(1) := FND_API.G_false );
25:
26:
27: g_miss_saveshare_control_rec SAVESHARE_CONTROL_REC_TYPE;
28:

Line 30: active_quote_id number :=FND_API.G_MISS_NUM ,

26:
27: g_miss_saveshare_control_rec SAVESHARE_CONTROL_REC_TYPE;
28:
29: TYPE ACTIVE_CARTS_REC_TYPE is record(
30: active_quote_id number :=FND_API.G_MISS_NUM ,
31: object_version_number number :=FND_API.G_MISS_NUM ,
32: quote_header_id number :=FND_API.G_MISS_NUM ,
33: party_id number :=FND_API.G_MISS_NUM ,
34: cust_account_id number :=FND_API.G_MISS_NUM ,

Line 31: object_version_number number :=FND_API.G_MISS_NUM ,

27: g_miss_saveshare_control_rec SAVESHARE_CONTROL_REC_TYPE;
28:
29: TYPE ACTIVE_CARTS_REC_TYPE is record(
30: active_quote_id number :=FND_API.G_MISS_NUM ,
31: object_version_number number :=FND_API.G_MISS_NUM ,
32: quote_header_id number :=FND_API.G_MISS_NUM ,
33: party_id number :=FND_API.G_MISS_NUM ,
34: cust_account_id number :=FND_API.G_MISS_NUM ,
35: creation_date date := FND_API.G_MISS_DATE,

Line 32: quote_header_id number :=FND_API.G_MISS_NUM ,

28:
29: TYPE ACTIVE_CARTS_REC_TYPE is record(
30: active_quote_id number :=FND_API.G_MISS_NUM ,
31: object_version_number number :=FND_API.G_MISS_NUM ,
32: quote_header_id number :=FND_API.G_MISS_NUM ,
33: party_id number :=FND_API.G_MISS_NUM ,
34: cust_account_id number :=FND_API.G_MISS_NUM ,
35: creation_date date := FND_API.G_MISS_DATE,
36: created_by number :=FND_API.G_MISS_NUM ,

Line 33: party_id number :=FND_API.G_MISS_NUM ,

29: TYPE ACTIVE_CARTS_REC_TYPE is record(
30: active_quote_id number :=FND_API.G_MISS_NUM ,
31: object_version_number number :=FND_API.G_MISS_NUM ,
32: quote_header_id number :=FND_API.G_MISS_NUM ,
33: party_id number :=FND_API.G_MISS_NUM ,
34: cust_account_id number :=FND_API.G_MISS_NUM ,
35: creation_date date := FND_API.G_MISS_DATE,
36: created_by number :=FND_API.G_MISS_NUM ,
37: last_update_date date := FND_API.G_MISS_DATE,

Line 34: cust_account_id number :=FND_API.G_MISS_NUM ,

30: active_quote_id number :=FND_API.G_MISS_NUM ,
31: object_version_number number :=FND_API.G_MISS_NUM ,
32: quote_header_id number :=FND_API.G_MISS_NUM ,
33: party_id number :=FND_API.G_MISS_NUM ,
34: cust_account_id number :=FND_API.G_MISS_NUM ,
35: creation_date date := FND_API.G_MISS_DATE,
36: created_by number :=FND_API.G_MISS_NUM ,
37: last_update_date date := FND_API.G_MISS_DATE,
38: last_updated_by number :=FND_API.G_MISS_NUM ,

Line 35: creation_date date := FND_API.G_MISS_DATE,

31: object_version_number number :=FND_API.G_MISS_NUM ,
32: quote_header_id number :=FND_API.G_MISS_NUM ,
33: party_id number :=FND_API.G_MISS_NUM ,
34: cust_account_id number :=FND_API.G_MISS_NUM ,
35: creation_date date := FND_API.G_MISS_DATE,
36: created_by number :=FND_API.G_MISS_NUM ,
37: last_update_date date := FND_API.G_MISS_DATE,
38: last_updated_by number :=FND_API.G_MISS_NUM ,
39: last_update_login number :=FND_API.G_MISS_NUM );

Line 36: created_by number :=FND_API.G_MISS_NUM ,

32: quote_header_id number :=FND_API.G_MISS_NUM ,
33: party_id number :=FND_API.G_MISS_NUM ,
34: cust_account_id number :=FND_API.G_MISS_NUM ,
35: creation_date date := FND_API.G_MISS_DATE,
36: created_by number :=FND_API.G_MISS_NUM ,
37: last_update_date date := FND_API.G_MISS_DATE,
38: last_updated_by number :=FND_API.G_MISS_NUM ,
39: last_update_login number :=FND_API.G_MISS_NUM );
40:

Line 37: last_update_date date := FND_API.G_MISS_DATE,

33: party_id number :=FND_API.G_MISS_NUM ,
34: cust_account_id number :=FND_API.G_MISS_NUM ,
35: creation_date date := FND_API.G_MISS_DATE,
36: created_by number :=FND_API.G_MISS_NUM ,
37: last_update_date date := FND_API.G_MISS_DATE,
38: last_updated_by number :=FND_API.G_MISS_NUM ,
39: last_update_login number :=FND_API.G_MISS_NUM );
40:
41: G_MISS_ACTIVE_CARTS_REC ACTIVE_CARTS_REC_TYPE;

Line 38: last_updated_by number :=FND_API.G_MISS_NUM ,

34: cust_account_id number :=FND_API.G_MISS_NUM ,
35: creation_date date := FND_API.G_MISS_DATE,
36: created_by number :=FND_API.G_MISS_NUM ,
37: last_update_date date := FND_API.G_MISS_DATE,
38: last_updated_by number :=FND_API.G_MISS_NUM ,
39: last_update_login number :=FND_API.G_MISS_NUM );
40:
41: G_MISS_ACTIVE_CARTS_REC ACTIVE_CARTS_REC_TYPE;
42:

Line 39: last_update_login number :=FND_API.G_MISS_NUM );

35: creation_date date := FND_API.G_MISS_DATE,
36: created_by number :=FND_API.G_MISS_NUM ,
37: last_update_date date := FND_API.G_MISS_DATE,
38: last_updated_by number :=FND_API.G_MISS_NUM ,
39: last_update_login number :=FND_API.G_MISS_NUM );
40:
41: G_MISS_ACTIVE_CARTS_REC ACTIVE_CARTS_REC_TYPE;
42:
43: PROCEDURE save_Contact_Point(

Line 45: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

41: G_MISS_ACTIVE_CARTS_REC ACTIVE_CARTS_REC_TYPE;
42:
43: PROCEDURE save_Contact_Point(
44: p_api_version_number IN NUMBER
45: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
46: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
47: ,P_URL IN VARCHAR2 := FND_API.G_MISS_char
48: ,P_EMAIL IN VARCHAR2 := FND_API.G_MISS_char
49: ,p_owner_table_id IN NUMBER

Line 46: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

42:
43: PROCEDURE save_Contact_Point(
44: p_api_version_number IN NUMBER
45: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
46: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
47: ,P_URL IN VARCHAR2 := FND_API.G_MISS_char
48: ,P_EMAIL IN VARCHAR2 := FND_API.G_MISS_char
49: ,p_owner_table_id IN NUMBER
50: ,p_mode IN VARCHAR2

Line 47: ,P_URL IN VARCHAR2 := FND_API.G_MISS_char

43: PROCEDURE save_Contact_Point(
44: p_api_version_number IN NUMBER
45: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
46: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
47: ,P_URL IN VARCHAR2 := FND_API.G_MISS_char
48: ,P_EMAIL IN VARCHAR2 := FND_API.G_MISS_char
49: ,p_owner_table_id IN NUMBER
50: ,p_mode IN VARCHAR2
51: ,x_contact_point_id OUT NOCOPY number

Line 48: ,P_EMAIL IN VARCHAR2 := FND_API.G_MISS_char

44: p_api_version_number IN NUMBER
45: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
46: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
47: ,P_URL IN VARCHAR2 := FND_API.G_MISS_char
48: ,P_EMAIL IN VARCHAR2 := FND_API.G_MISS_char
49: ,p_owner_table_id IN NUMBER
50: ,p_mode IN VARCHAR2
51: ,x_contact_point_id OUT NOCOPY number
52: ,X_Return_Status OUT NOCOPY VARCHAR2

Line 66: P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,

62: P_retrieval_number IN NUMBER ,
63: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
64: P_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
65: := ibe_quote_saveshare_pvt.G_MISS_QUOTE_ACCESS_TBL,
66: P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
67: P_source_last_update_date IN DATE := FND_API.G_MISS_DATE ,
68: p_minisite_id IN NUMBER ,
69: p_URL IN VARCHAR2 ,
70: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 67: P_source_last_update_date IN DATE := FND_API.G_MISS_DATE ,

63: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
64: P_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
65: := ibe_quote_saveshare_pvt.G_MISS_QUOTE_ACCESS_TBL,
66: P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
67: P_source_last_update_date IN DATE := FND_API.G_MISS_DATE ,
68: p_minisite_id IN NUMBER ,
69: p_URL IN VARCHAR2 ,
70: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
71: p_api_version IN NUMBER := 1 ,

Line 70: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,

66: P_source_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
67: P_source_last_update_date IN DATE := FND_API.G_MISS_DATE ,
68: p_minisite_id IN NUMBER ,
69: p_URL IN VARCHAR2 ,
70: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
71: p_api_version IN NUMBER := 1 ,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74: x_return_status OUT NOCOPY VARCHAR2 ,

Line 72: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

68: p_minisite_id IN NUMBER ,
69: p_URL IN VARCHAR2 ,
70: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
71: p_api_version IN NUMBER := 1 ,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74: x_return_status OUT NOCOPY VARCHAR2 ,
75: x_msg_count OUT NOCOPY NUMBER ,
76: x_msg_data OUT NOCOPY VARCHAR2 );

Line 73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

69: p_URL IN VARCHAR2 ,
70: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
71: p_api_version IN NUMBER := 1 ,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74: x_return_status OUT NOCOPY VARCHAR2 ,
75: x_msg_count OUT NOCOPY NUMBER ,
76: x_msg_data OUT NOCOPY VARCHAR2 );
77:

Line 82: P_Party_id IN Number := FND_API.G_MISS_NUM ,

78: Procedure SAVE_RECIPIENTS (
79: P_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
80: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
81: P_Quote_header_id IN Number ,
82: P_Party_id IN Number := FND_API.G_MISS_NUM ,
83: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
84: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
85: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
86: p_send_notif IN Varchar2 := FND_API.G_TRUE ,

Line 83: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,

79: P_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
80: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
81: P_Quote_header_id IN Number ,
82: P_Party_id IN Number := FND_API.G_MISS_NUM ,
83: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
84: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
85: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
86: p_send_notif IN Varchar2 := FND_API.G_TRUE ,
87: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,

Line 84: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,

80: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
81: P_Quote_header_id IN Number ,
82: P_Party_id IN Number := FND_API.G_MISS_NUM ,
83: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
84: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
85: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
86: p_send_notif IN Varchar2 := FND_API.G_TRUE ,
87: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
88: p_api_version IN NUMBER := 1 ,

Line 85: P_minisite_id IN Number := FND_API.G_MISS_NUM ,

81: P_Quote_header_id IN Number ,
82: P_Party_id IN Number := FND_API.G_MISS_NUM ,
83: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
84: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
85: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
86: p_send_notif IN Varchar2 := FND_API.G_TRUE ,
87: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
88: p_api_version IN NUMBER := 1 ,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 86: p_send_notif IN Varchar2 := FND_API.G_TRUE ,

82: P_Party_id IN Number := FND_API.G_MISS_NUM ,
83: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
84: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
85: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
86: p_send_notif IN Varchar2 := FND_API.G_TRUE ,
87: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
88: p_api_version IN NUMBER := 1 ,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 87: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,

83: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
84: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
85: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
86: p_send_notif IN Varchar2 := FND_API.G_TRUE ,
87: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
88: p_api_version IN NUMBER := 1 ,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
91: x_return_status OUT NOCOPY VARCHAR2 ,

Line 89: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

85: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
86: p_send_notif IN Varchar2 := FND_API.G_TRUE ,
87: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
88: p_api_version IN NUMBER := 1 ,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
91: x_return_status OUT NOCOPY VARCHAR2 ,
92: x_msg_count OUT NOCOPY NUMBER ,
93: x_msg_data OUT NOCOPY VARCHAR2 );

Line 90: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

86: p_send_notif IN Varchar2 := FND_API.G_TRUE ,
87: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
88: p_api_version IN NUMBER := 1 ,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
91: x_return_status OUT NOCOPY VARCHAR2 ,
92: x_msg_count OUT NOCOPY NUMBER ,
93: x_msg_data OUT NOCOPY VARCHAR2 );
94:

Line 97: P_Party_id IN Number := FND_API.G_MISS_NUM ,

93: x_msg_data OUT NOCOPY VARCHAR2 );
94:
95: Procedure ACTIVATE_QUOTE (
96: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
97: P_Party_id IN Number := FND_API.G_MISS_NUM ,
98: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
99: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
100: := ASO_QUOTE_PUB.G_MISS_Control_Rec,
101: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,

Line 98: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,

94:
95: Procedure ACTIVATE_QUOTE (
96: P_Quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
97: P_Party_id IN Number := FND_API.G_MISS_NUM ,
98: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
99: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
100: := ASO_QUOTE_PUB.G_MISS_Control_Rec,
101: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
102: p_api_version IN NUMBER := 1 ,

Line 101: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,

97: P_Party_id IN Number := FND_API.G_MISS_NUM ,
98: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
99: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
100: := ASO_QUOTE_PUB.G_MISS_Control_Rec,
101: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
102: p_api_version IN NUMBER := 1 ,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
105: x_return_status OUT NOCOPY VARCHAR2 ,

Line 103: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

99: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
100: := ASO_QUOTE_PUB.G_MISS_Control_Rec,
101: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
102: p_api_version IN NUMBER := 1 ,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
105: x_return_status OUT NOCOPY VARCHAR2 ,
106: x_msg_count OUT NOCOPY NUMBER ,
107: x_msg_data OUT NOCOPY VARCHAR2 );

Line 104: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

100: := ASO_QUOTE_PUB.G_MISS_Control_Rec,
101: p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
102: p_api_version IN NUMBER := 1 ,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
105: x_return_status OUT NOCOPY VARCHAR2 ,
106: x_msg_count OUT NOCOPY NUMBER ,
107: x_msg_data OUT NOCOPY VARCHAR2 );
108:

Line 111: P_Party_id IN Number := FND_API.G_MISS_NUM ,

107: x_msg_data OUT NOCOPY VARCHAR2 );
108:
109: Procedure DEACTIVATE_QUOTE (
110: P_Quote_header_id IN Number ,
111: P_Party_id IN Number := FND_API.G_MISS_NUM ,
112: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
113: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
114: p_api_version IN NUMBER := 1 ,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 112: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,

108:
109: Procedure DEACTIVATE_QUOTE (
110: P_Quote_header_id IN Number ,
111: P_Party_id IN Number := FND_API.G_MISS_NUM ,
112: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
113: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
114: p_api_version IN NUMBER := 1 ,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 113: P_minisite_id IN Number := FND_API.G_MISS_NUM ,

109: Procedure DEACTIVATE_QUOTE (
110: P_Quote_header_id IN Number ,
111: P_Party_id IN Number := FND_API.G_MISS_NUM ,
112: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
113: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
114: p_api_version IN NUMBER := 1 ,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
117: x_return_status OUT NOCOPY VARCHAR2 ,

Line 115: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

111: P_Party_id IN Number := FND_API.G_MISS_NUM ,
112: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
113: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
114: p_api_version IN NUMBER := 1 ,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: x_msg_count OUT NOCOPY NUMBER ,
119: x_msg_data OUT NOCOPY VARCHAR2 );

Line 116: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

112: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
113: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
114: p_api_version IN NUMBER := 1 ,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: x_msg_count OUT NOCOPY NUMBER ,
119: x_msg_data OUT NOCOPY VARCHAR2 );
120:

Line 127: P_delete_source_cart IN Varchar2 := FND_API.G_TRUE ,

123: P_source_last_update_date IN Date ,
124: P_target_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
125: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
126: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
127: P_delete_source_cart IN Varchar2 := FND_API.G_TRUE ,
128: P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,
129: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
130: p_api_version IN NUMBER := 1 ,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 128: P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,

124: P_target_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
125: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
126: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
127: P_delete_source_cart IN Varchar2 := FND_API.G_TRUE ,
128: P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,
129: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
130: p_api_version IN NUMBER := 1 ,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 129: P_minisite_id IN Number := FND_API.G_MISS_NUM ,

125: P_control_rec IN ASO_QUOTE_PUB.control_rec_type
126: := ASO_QUOTE_PUB.G_MISS_Control_Rec ,
127: P_delete_source_cart IN Varchar2 := FND_API.G_TRUE ,
128: P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,
129: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
130: p_api_version IN NUMBER := 1 ,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: x_return_status OUT NOCOPY VARCHAR2 ,

Line 131: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

127: P_delete_source_cart IN Varchar2 := FND_API.G_TRUE ,
128: P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,
129: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
130: p_api_version IN NUMBER := 1 ,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: x_return_status OUT NOCOPY VARCHAR2 ,
134: x_msg_count OUT NOCOPY NUMBER ,
135: x_msg_data OUT NOCOPY VARCHAR2 );

Line 132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

128: P_combinesameitem IN Varchar2 := FND_API.G_TRUE ,
129: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
130: p_api_version IN NUMBER := 1 ,
131: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: x_return_status OUT NOCOPY VARCHAR2 ,
134: x_msg_count OUT NOCOPY NUMBER ,
135: x_msg_data OUT NOCOPY VARCHAR2 );
136:

Line 141: P_minisite_id IN Number := FND_API.G_MISS_NUM ,

137:
138: Procedure STOP_SHARING (
139: p_quote_header_id IN NUMBER ,
140: p_delete_context IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
141: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
142: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
143: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
144: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
145: p_api_version IN NUMBER := 1 ,

Line 142: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,

138: Procedure STOP_SHARING (
139: p_quote_header_id IN NUMBER ,
140: p_delete_context IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
141: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
142: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
143: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
144: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
145: p_api_version IN NUMBER := 1 ,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 146: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

142: p_notes IN Varchar2 := FND_API.G_MISS_CHAR ,
143: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
144: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
145: p_api_version IN NUMBER := 1 ,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
148: x_return_status OUT NOCOPY VARCHAR2 ,
149: x_msg_count OUT NOCOPY NUMBER ,
150: x_msg_data OUT NOCOPY VARCHAR2 );

Line 147: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

143: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
144: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
145: p_api_version IN NUMBER := 1 ,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
148: x_return_status OUT NOCOPY VARCHAR2 ,
149: x_msg_count OUT NOCOPY NUMBER ,
150: x_msg_data OUT NOCOPY VARCHAR2 );
151:

Line 156: P_Party_id IN Number := FND_API.G_MISS_NUM ,

152: Procedure END_WORKING (
153: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
154: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
155: P_Quote_header_id IN Number ,
156: P_Party_id IN Number := FND_API.G_MISS_NUM ,
157: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
158: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,
159: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
160: P_minisite_id IN Number := FND_API.G_MISS_NUM ,

Line 157: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,

153: p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
154: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
155: P_Quote_header_id IN Number ,
156: P_Party_id IN Number := FND_API.G_MISS_NUM ,
157: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
158: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,
159: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
160: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
161: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 158: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,

154: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl,
155: P_Quote_header_id IN Number ,
156: P_Party_id IN Number := FND_API.G_MISS_NUM ,
157: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
158: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,
159: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
160: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
161: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
162: p_api_version IN NUMBER := 1 ,

Line 159: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,

155: P_Quote_header_id IN Number ,
156: P_Party_id IN Number := FND_API.G_MISS_NUM ,
157: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
158: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,
159: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
160: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
161: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
162: p_api_version IN NUMBER := 1 ,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 160: P_minisite_id IN Number := FND_API.G_MISS_NUM ,

156: P_Party_id IN Number := FND_API.G_MISS_NUM ,
157: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
158: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,
159: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
160: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
161: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
162: p_api_version IN NUMBER := 1 ,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 161: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,

157: P_Cust_account_id IN Number := FND_API.G_MISS_NUM ,
158: p_retrieval_number IN Number := FND_API.G_MISS_NUM ,
159: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
160: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
161: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
162: p_api_version IN NUMBER := 1 ,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
165: x_return_status OUT NOCOPY VARCHAR2 ,

Line 163: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

159: P_URL IN Varchar2 := FND_API.G_MISS_CHAR ,
160: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
161: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
162: p_api_version IN NUMBER := 1 ,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
165: x_return_status OUT NOCOPY VARCHAR2 ,
166: x_msg_count OUT NOCOPY NUMBER ,
167: x_msg_data OUT NOCOPY VARCHAR2 );

Line 164: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

160: P_minisite_id IN Number := FND_API.G_MISS_NUM ,
161: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
162: p_api_version IN NUMBER := 1 ,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
165: x_return_status OUT NOCOPY VARCHAR2 ,
166: x_msg_count OUT NOCOPY NUMBER ,
167: x_msg_data OUT NOCOPY VARCHAR2 );
168:

Line 171: P_minisite_id IN Number := FND_API.G_MISS_NUM,

167: x_msg_data OUT NOCOPY VARCHAR2 );
168:
169: Procedure SHARE_READONLY (
170: p_quote_header_id IN Number ,
171: P_minisite_id IN Number := FND_API.G_MISS_NUM,
172: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
173:
174: p_api_version IN NUMBER := 1 ,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 172: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,

168:
169: Procedure SHARE_READONLY (
170: p_quote_header_id IN Number ,
171: P_minisite_id IN Number := FND_API.G_MISS_NUM,
172: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
173:
174: p_api_version IN NUMBER := 1 ,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

171: P_minisite_id IN Number := FND_API.G_MISS_NUM,
172: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
173:
174: p_api_version IN NUMBER := 1 ,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
177: x_return_status OUT NOCOPY VARCHAR2 ,
178: x_msg_count OUT NOCOPY NUMBER ,
179: x_msg_data OUT NOCOPY VARCHAR2 );

Line 176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

172: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
173:
174: p_api_version IN NUMBER := 1 ,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
177: x_return_status OUT NOCOPY VARCHAR2 ,
178: x_msg_count OUT NOCOPY NUMBER ,
179: x_msg_data OUT NOCOPY VARCHAR2 );
180:

Line 186: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,

182: P_Quote_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE
183: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC,
184: p_minisite_id IN NUMBER ,
185: p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
186: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,
187: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
188: p_api_version IN NUMBER := 1 ,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 187: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,

183: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC,
184: p_minisite_id IN NUMBER ,
185: p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
186: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,
187: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
188: p_api_version IN NUMBER := 1 ,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
191: x_return_status OUT NOCOPY VARCHAR2 ,

Line 189: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

185: p_delete_code IN VARCHAR2 := 'IBE_SC_CART_STOPSHARING' ,
186: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,
187: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
188: p_api_version IN NUMBER := 1 ,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
191: x_return_status OUT NOCOPY VARCHAR2 ,
192: x_msg_count OUT NOCOPY NUMBER ,
193: x_msg_data OUT NOCOPY VARCHAR2 );

Line 190: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

186: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR ,
187: p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR ,
188: p_api_version IN NUMBER := 1 ,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
191: x_return_status OUT NOCOPY VARCHAR2 ,
192: x_msg_count OUT NOCOPY NUMBER ,
193: x_msg_data OUT NOCOPY VARCHAR2 );
194:

Line 197: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

193: x_msg_data OUT NOCOPY VARCHAR2 );
194:
195: PROCEDURE Validate_share_Update(
196: p_api_version_number IN NUMBER := 1.0
197: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
198: ,p_quote_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
199: ,p_quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Tbl_Type
200: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
201: -- partyid and accountid cannot be gmiss coming in

Line 204: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

200: := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl
201: -- partyid and accountid cannot be gmiss coming in
202: ,p_party_id IN NUMBER
203: ,p_cust_account_id IN NUMBER
204: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
205: ,p_operation_code IN VARCHAR2
206: ,x_return_status OUT NOCOPY VARCHAR2
207: ,x_msg_count OUT NOCOPY NUMBER
208: ,x_msg_data OUT NOCOPY VARCHAR2);