DBA Data[Home] [Help]

APPS.IBE_ORD_ONECLICK_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 75: l_usage_codes JTF_VARCHAR2_TABLE_100 ;

71: owner_table_name = 'HZ_PARTIES' and
72: status = 'A' and
73: owner_table_id = owner_id and primary_flag = 'Y';
74:
75: l_usage_codes JTF_VARCHAR2_TABLE_100 ;
76: l_return_codes JTF_VARCHAR2_TABLE_100 ;
77: l_org_id NUMBER;
78: l_save_flag VARCHAR2(1) := 'N';
79:

Line 76: l_return_codes JTF_VARCHAR2_TABLE_100 ;

72: status = 'A' and
73: owner_table_id = owner_id and primary_flag = 'Y';
74:
75: l_usage_codes JTF_VARCHAR2_TABLE_100 ;
76: l_return_codes JTF_VARCHAR2_TABLE_100 ;
77: l_org_id NUMBER;
78: l_save_flag VARCHAR2(1) := 'N';
79:
80: l_cvv2_setup VARCHAR2(1);

Line 177: l_usage_codes := JTF_VARCHAR2_TABLE_100(1);

173: END IF;
174: l_org_id := MO_GLOBAL.get_current_org_id();
175: -- in case of a single org env the feature of addr usages is unsupported
176: if (l_org_id is not null and l_org_id <> 0) then
177: l_usage_codes := JTF_VARCHAR2_TABLE_100(1);
178: l_return_codes := JTF_VARCHAR2_TABLE_100(1);
179:
180: if (x_BILL_PTYSITE_ID is not null) then
181: -- call address validation apis; if either is not valid turn settings off

Line 178: l_return_codes := JTF_VARCHAR2_TABLE_100(1);

174: l_org_id := MO_GLOBAL.get_current_org_id();
175: -- in case of a single org env the feature of addr usages is unsupported
176: if (l_org_id is not null and l_org_id <> 0) then
177: l_usage_codes := JTF_VARCHAR2_TABLE_100(1);
178: l_return_codes := JTF_VARCHAR2_TABLE_100(1);
179:
180: if (x_BILL_PTYSITE_ID is not null) then
181: -- call address validation apis; if either is not valid turn settings off
182: l_usage_codes(1) := 'BILL_TO_COUNTRY';

Line 613: p_uom_codes IN JTF_VARCHAR2_TABLE_100,

609: -- for express checkout of a list of items (usually from catalog)
610: p_item_ids IN JTF_NUMBER_TABLE,
611: p_qtys IN JTF_NUMBER_TABLE,
612: p_org_ids IN JTF_NUMBER_TABLE,
613: p_uom_codes IN JTF_VARCHAR2_TABLE_100,
614:
615: -- return the quote header id
616: x_new_cart_id OUT NOCOPY NUMBER,
617: