DBA Data[Home] [Help]

APPS.PV_ASSIGNMENT_PUB dependencies on JTF_VARCHAR2_TABLE_100

Line 41: p_partner_source_tbl in JTF_VARCHAR2_TABLE_100,

37: p_assignment_type in VARCHAR2,
38: p_bypass_cm_ok_flag in VARCHAR2,
39: p_partner_id_tbl in JTF_NUMBER_TABLE,
40: p_rank_tbl in JTF_NUMBER_TABLE,
41: p_partner_source_tbl in JTF_VARCHAR2_TABLE_100,
42: p_process_rule_id in NUMBER,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY VARCHAR2) is

Line 1244: p_statusTbl in JTF_VARCHAR2_TABLE_100, -- CM_APPROVED,CM_REJECTED,CM_ADDED,NOACTION,CM_APP_FOR_PT,CM_ADD_APP_FOR_PT

1240: p_user_name IN VARCHAR2,
1241: p_lead_id IN NUMBER,
1242: p_partyTbl in JTF_NUMBER_TABLE,
1243: p_rank_Tbl in JTF_NUMBER_TABLE,
1244: p_statusTbl in JTF_VARCHAR2_TABLE_100, -- CM_APPROVED,CM_REJECTED,CM_ADDED,NOACTION,CM_APP_FOR_PT,CM_ADD_APP_FOR_PT
1245: x_return_status OUT NOCOPY VARCHAR2,
1246: x_msg_count OUT NOCOPY NUMBER,
1247: x_msg_data OUT NOCOPY VARCHAR2) is
1248:

Line 3425: l_user_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

3421: l_customer_id NUMBER;
3422: l_address_id NUMBER;
3423: l_lead_number VARCHAR2(30);
3424:
3425: l_user_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
3426: l_user_name_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
3427:
3428:
3429: l_party_notify_rec pv_assign_util_pvt.party_notify_rec_type;

Line 3426: l_user_name_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

3422: l_address_id NUMBER;
3423: l_lead_number VARCHAR2(30);
3424:
3425: l_user_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
3426: l_user_name_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
3427:
3428:
3429: l_party_notify_rec pv_assign_util_pvt.party_notify_rec_type;
3430: l_attrib_values_rec pv_assignment_pvt.attrib_values_rec_type;