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.POS_MERGE_SUPPLIER_PKG dependencies on POS_SUPP_PROF_EXT_B

Line 11: TYPE uda_rec_tbl_type IS TABLE OF pos_supp_prof_ext_b%ROWTYPE INDEX BY BINARY_INTEGER;

7: payment_function iby_pmt_instr_uses_all.payment_function%TYPE);
8:
9: TYPE bank_dtls_tab_type IS TABLE OF bank_dtls_rec_type INDEX BY BINARY_INTEGER;
10:
11: TYPE uda_rec_tbl_type IS TABLE OF pos_supp_prof_ext_b%ROWTYPE INDEX BY BINARY_INTEGER;
12:
13: TYPE attributes_rec IS RECORD(
14: attr_name ego_attrs_v.attr_name%TYPE,
15: database_column ego_attrs_v.database_column%TYPE);

Line 913: FROM pos_supp_prof_ext_b

909: x_msg_data OUT NOCOPY VARCHAR2
910: ) IS
911: CURSOR multirow_cur IS
912: SELECT *
913: FROM pos_supp_prof_ext_b
914: WHERE attr_group_id = p_attribute_group_id
915: AND data_level_id = p_data_level_id
916: AND party_id IN ( -- Only from parties
917: SELECT from_party_id

Line 928: FROM pos_supp_prof_ext_b

924:
925: CURSOR singlerow_cur IS
926: SELECT *
927: FROM (SELECT *
928: FROM pos_supp_prof_ext_b
929: WHERE attr_group_id = p_attribute_group_id
930: AND data_level_id = p_data_level_id
931: AND party_id IN
932: (SELECT from_party_id

Line 939: FROM pos_supp_prof_ext_b

935: AND merge_type <> 'SAME_PARTY_MERGE'
936: AND to_party_id = p_to_party_id)
937: ORDER BY last_update_date)
938: UNION ALL (SELECT *
939: FROM pos_supp_prof_ext_b
940: WHERE attr_group_id = p_attribute_group_id
941: AND data_level_id = p_data_level_id
942: AND party_id = p_to_party_id);
943: BEGIN

Line 991: FROM pos_supp_prof_ext_b

987: ) IS
988:
989: CURSOR multirow_cur IS
990: SELECT *
991: FROM pos_supp_prof_ext_b
992: WHERE attr_group_id = p_attribute_group_id
993: AND data_level_id = p_data_level_id
994: AND (party_id, pk1_value) IN
995: (SELECT fromparty.party_id,

Line 1015: FROM pos_supp_prof_ext_b

1011:
1012: CURSOR singlerow_cur IS
1013: SELECT *
1014: FROM (SELECT *
1015: FROM pos_supp_prof_ext_b
1016: WHERE attr_group_id = p_attribute_group_id
1017: AND data_level_id = p_data_level_id
1018: AND (party_id, pk1_value) IN
1019: (SELECT fromparty.party_id,

Line 1038: FROM pos_supp_prof_ext_b

1034: AND merge_from_entity_id = p_from_party_id))
1035: ORDER BY last_update_date)
1036: UNION ALL
1037: SELECT *
1038: FROM pos_supp_prof_ext_b
1039: WHERE attr_group_id = p_attribute_group_id
1040: AND data_level_id = p_data_level_id
1041: AND pk1_value = p_to_party_id;
1042: BEGIN

Line 1077: FROM pos_supp_prof_ext_b

1073: ) IS
1074:
1075: CURSOR multirow_cur IS
1076: SELECT *
1077: FROM pos_supp_prof_ext_b
1078: WHERE attr_group_id = p_attribute_group_id
1079: AND data_level_id = p_data_level_id
1080: AND pk2_value = p_from_party_id
1081: ORDER BY last_update_date;

Line 1085: FROM pos_supp_prof_ext_b

1081: ORDER BY last_update_date;
1082:
1083: CURSOR singlerow_cur IS
1084: SELECT *
1085: FROM pos_supp_prof_ext_b
1086: WHERE attr_group_id = p_attribute_group_id
1087: AND data_level_id = p_data_level_id
1088: AND pk2_value = p_from_party_id
1089: UNION ALL

Line 1091: FROM pos_supp_prof_ext_b

1087: AND data_level_id = p_data_level_id
1088: AND pk2_value = p_from_party_id
1089: UNION ALL
1090: SELECT *
1091: FROM pos_supp_prof_ext_b
1092: WHERE attr_group_id = p_attribute_group_id
1093: AND data_level_id = p_data_level_id
1094: AND pk2_value = p_to_party_id;
1095: BEGIN

Line 1121: p_uda_data_rec IN pos_supp_prof_ext_b%ROWTYPE,

1117: p_attribute_group_id IN NUMBER,
1118: p_attribute_group_type IN VARCHAR2,
1119: p_attribute_group_name IN VARCHAR2,
1120: p_row_identifier IN NUMBER,
1121: p_uda_data_rec IN pos_supp_prof_ext_b%ROWTYPE,
1122: x_attributes_data_table IN OUT NOCOPY ego_user_attr_data_table
1123: ) IS
1124:
1125: CURSOR get_attributes IS

Line 2525: x_uda_rec OUT NOCOPY pos_supp_prof_ext_b%ROWTYPE,

2521:
2522: PROCEDURE do_single_row_uda_merge
2523: (
2524: p_uda_rec_tbl IN OUT NOCOPY uda_rec_tbl_type,
2525: x_uda_rec OUT NOCOPY pos_supp_prof_ext_b%ROWTYPE,
2526: x_return_status OUT NOCOPY VARCHAR2,
2527: x_msg_count OUT NOCOPY NUMBER,
2528: x_msg_data OUT NOCOPY VARCHAR2
2529: ) IS

Line 2803: l_uda_data_rec pos_supp_prof_ext_b%ROWTYPE;

2799:
2800: l_row_identifier NUMBER;
2801: l_uda_rec_tbl uda_rec_tbl_type;
2802:
2803: l_uda_data_rec pos_supp_prof_ext_b%ROWTYPE;
2804: l_failed_row_id_buffer VARCHAR2(1000);
2805:
2806: l_return_status VARCHAR2(2000);
2807: l_msg_count NUMBER;

Line 3135: FROM pos_supp_prof_ext_b pos1,

3131: key_col_val := NULL;
3132:
3133: IF (p_data_level_id = 17701) THEN
3134: l_sql := 'SELECT pos1.extension_id to_ext_id
3135: FROM pos_supp_prof_ext_b pos1,
3136: pos_supp_prof_ext_b pos2
3137: WHERE pos1.attr_group_id = ' || p_attribute_group_id ||
3138: ' AND pos1.data_level_id = ' || p_data_level_id ||
3139: ' AND pos1.attr_group_id = pos2.attr_group_id

Line 3136: pos_supp_prof_ext_b pos2

3132:
3133: IF (p_data_level_id = 17701) THEN
3134: l_sql := 'SELECT pos1.extension_id to_ext_id
3135: FROM pos_supp_prof_ext_b pos1,
3136: pos_supp_prof_ext_b pos2
3137: WHERE pos1.attr_group_id = ' || p_attribute_group_id ||
3138: ' AND pos1.data_level_id = ' || p_data_level_id ||
3139: ' AND pos1.attr_group_id = pos2.attr_group_id
3140: AND pos1.data_level_id = pos2.data_level_id

Line 3148: FROM pos_supp_prof_ext_b pos1,

3144: p_to_party_id || where_clause;
3145:
3146: ELSIF (p_data_level_id = 17702) THEN
3147: l_sql := 'SELECT pos1.extension_id to_ext_id
3148: FROM pos_supp_prof_ext_b pos1,
3149: pos_supp_prof_ext_b pos2
3150: WHERE pos1.attr_group_id = ' || p_attribute_group_id ||
3151: ' AND pos1.data_level_id = ' || p_data_level_id ||
3152: ' AND pos1.attr_group_id = pos2.attr_group_id

Line 3149: pos_supp_prof_ext_b pos2

3145:
3146: ELSIF (p_data_level_id = 17702) THEN
3147: l_sql := 'SELECT pos1.extension_id to_ext_id
3148: FROM pos_supp_prof_ext_b pos1,
3149: pos_supp_prof_ext_b pos2
3150: WHERE pos1.attr_group_id = ' || p_attribute_group_id ||
3151: ' AND pos1.data_level_id = ' || p_data_level_id ||
3152: ' AND pos1.attr_group_id = pos2.attr_group_id
3153: AND pos1.data_level_id = pos2.data_level_id

Line 3162: FROM pos_supp_prof_ext_b pos1,

3158: where_clause;
3159:
3160: ELSIF (p_data_level_id = 17703) THEN
3161: l_sql := 'SELECT pos1.extension_id to_ext_id
3162: FROM pos_supp_prof_ext_b pos1,
3163: pos_supp_prof_ext_b pos2
3164: WHERE pos1.attr_group_id = ' || p_attribute_group_id ||
3165: ' AND pos1.data_level_id = ' || p_data_level_id ||
3166: ' AND pos1.attr_group_id = pos2.attr_group_id

Line 3163: pos_supp_prof_ext_b pos2

3159:
3160: ELSIF (p_data_level_id = 17703) THEN
3161: l_sql := 'SELECT pos1.extension_id to_ext_id
3162: FROM pos_supp_prof_ext_b pos1,
3163: pos_supp_prof_ext_b pos2
3164: WHERE pos1.attr_group_id = ' || p_attribute_group_id ||
3165: ' AND pos1.data_level_id = ' || p_data_level_id ||
3166: ' AND pos1.attr_group_id = pos2.attr_group_id
3167: AND pos1.data_level_id = pos2.data_level_id

Line 3187: FROM pos_supp_prof_ext_b

3183: IF key_combination_exists = FALSE THEN
3184: -- update multirow suchita
3185: IF (p_data_level_id = 17701) THEN
3186: l_sql := 'SELECT *
3187: FROM pos_supp_prof_ext_b
3188: WHERE party_id = ' || p_uda_rec_tbl(datacntr)
3189: .party_id || ' AND extension_id = ' || p_uda_rec_tbl(datacntr)
3190: .extension_id ||
3191: ' UNION ALL

Line 3193: FROM pos_supp_prof_ext_b

3189: .party_id || ' AND extension_id = ' || p_uda_rec_tbl(datacntr)
3190: .extension_id ||
3191: ' UNION ALL
3192: SELECT *
3193: FROM pos_supp_prof_ext_b
3194: WHERE party_id = ' ||
3195: p_to_party_id || ' AND extension_id = ' || l_ext1;
3196:
3197: ELSIF (p_data_level_id = 17702) THEN

Line 3199: FROM pos_supp_prof_ext_b

3195: p_to_party_id || ' AND extension_id = ' || l_ext1;
3196:
3197: ELSIF (p_data_level_id = 17702) THEN
3198: l_sql := 'SELECT *
3199: FROM pos_supp_prof_ext_b
3200: WHERE pk1_value = ' || p_uda_rec_tbl(datacntr)
3201: .pk1_value || ' AND extension_id = ' || p_uda_rec_tbl(datacntr)
3202: .extension_id ||
3203: ' UNION ALL

Line 3205: FROM pos_supp_prof_ext_b

3201: .pk1_value || ' AND extension_id = ' || p_uda_rec_tbl(datacntr)
3202: .extension_id ||
3203: ' UNION ALL
3204: SELECT *
3205: FROM pos_supp_prof_ext_b
3206: WHERE pk1_value = ' ||
3207: p_to_party_id || ' AND extension_id = ' || l_ext1;
3208:
3209: ELSIF (p_data_level_id = 17703) THEN

Line 3211: FROM pos_supp_prof_ext_b

3207: p_to_party_id || ' AND extension_id = ' || l_ext1;
3208:
3209: ELSIF (p_data_level_id = 17703) THEN
3210: l_sql := 'SELECT *
3211: FROM pos_supp_prof_ext_b
3212: WHERE pk2_value = ' || p_uda_rec_tbl(datacntr)
3213: .pk2_value || ' AND extension_id = ' || p_uda_rec_tbl(datacntr)
3214: .extension_id ||
3215: ' UNION ALL

Line 3217: FROM pos_supp_prof_ext_b

3213: .pk2_value || ' AND extension_id = ' || p_uda_rec_tbl(datacntr)
3214: .extension_id ||
3215: ' UNION ALL
3216: SELECT *
3217: FROM pos_supp_prof_ext_b
3218: WHERE pk2_value = ' ||
3219: p_to_party_id || ' AND extension_id = ' || l_ext1;
3220: END IF;
3221: ELSE

Line 3225: FROM pos_supp_prof_ext_b

3221: ELSE
3222: -- update multirow suchita
3223: IF (p_data_level_id = 17701) THEN
3224: l_sql := 'SELECT *
3225: FROM pos_supp_prof_ext_b
3226: WHERE party_id = ' || p_to_party_id ||
3227: ' AND extension_id = ' || l_ext1 ||
3228: 'UNION ALL
3229: SELECT *

Line 3230: FROM pos_supp_prof_ext_b

3226: WHERE party_id = ' || p_to_party_id ||
3227: ' AND extension_id = ' || l_ext1 ||
3228: 'UNION ALL
3229: SELECT *
3230: FROM pos_supp_prof_ext_b
3231: WHERE party_id = ' || p_uda_rec_tbl(datacntr)
3232: .party_id || ' AND extension_id = ' || p_uda_rec_tbl(datacntr)
3233: .extension_id;
3234:

Line 3237: FROM pos_supp_prof_ext_b

3233: .extension_id;
3234:
3235: ELSIF (p_data_level_id = 17702) THEN
3236: l_sql := 'SELECT *
3237: FROM pos_supp_prof_ext_b
3238: WHERE pk1_value = ' ||
3239: p_to_party_id || ' AND extension_id = ' || l_ext1 ||
3240: ' UNION ALL
3241: SELECT *

Line 3242: FROM pos_supp_prof_ext_b

3238: WHERE pk1_value = ' ||
3239: p_to_party_id || ' AND extension_id = ' || l_ext1 ||
3240: ' UNION ALL
3241: SELECT *
3242: FROM pos_supp_prof_ext_b
3243: WHERE pk1_value = ' || p_uda_rec_tbl(datacntr)
3244: .pk1_value || ' AND extension_id = ' || p_uda_rec_tbl(datacntr)
3245: .extension_id;
3246:

Line 3249: FROM pos_supp_prof_ext_b

3245: .extension_id;
3246:
3247: ELSIF (p_data_level_id = 17703) THEN
3248: l_sql := 'SELECT *
3249: FROM pos_supp_prof_ext_b
3250: WHERE pk2_value = ' ||
3251: p_to_party_id || ' AND extension_id = ' || l_ext1 ||
3252: ' UNION ALL
3253: SELECT *

Line 3254: FROM pos_supp_prof_ext_b

3250: WHERE pk2_value = ' ||
3251: p_to_party_id || ' AND extension_id = ' || l_ext1 ||
3252: ' UNION ALL
3253: SELECT *
3254: FROM pos_supp_prof_ext_b
3255: WHERE pk2_value = ' || p_uda_rec_tbl(datacntr)
3256: .pk2_value || ' AND extension_id = ' || p_uda_rec_tbl(datacntr)
3257: .extension_id;
3258: END IF;

Line 3534: p_uda_rec IN pos_supp_prof_ext_b%ROWTYPE,

3530: p_attribute_group_type IN VARCHAR2,
3531: p_attribute_group_name IN VARCHAR2,
3532: p_to_party_id IN NUMBER,
3533: p_mode IN VARCHAR2,
3534: p_uda_rec IN pos_supp_prof_ext_b%ROWTYPE,
3535: p_class_code IN VARCHAR2,
3536: p_vendor_id IN NUMBER DEFAULT NULL,
3537: --p_uda_rec_tbl IN uda_rec_tbl_type,
3538: x_return_status OUT NOCOPY VARCHAR2,

Line 3811: merged_uda_rec pos_supp_prof_ext_b%ROWTYPE;

3807: l_msg_count NUMBER;
3808: l_msg_data VARCHAR2(2000);
3809:
3810: l_uda_rec_tbl uda_rec_tbl_type;
3811: merged_uda_rec pos_supp_prof_ext_b%ROWTYPE;
3812: l_party_count NUMBER := 0;
3813: l_to_party_cntr NUMBER := 0;
3814:
3815: CURSOR get_supplier_attribute_groups IS

Line 3904: FROM pos_supp_prof_ext_b

3900: l_msg_data);
3901:
3902: SELECT COUNT(1)
3903: INTO l_party_count
3904: FROM pos_supp_prof_ext_b
3905: WHERE attr_group_id = attributes_group_coll(cntr).attr_group_id
3906: AND party_id = p_to_fk_id
3907: AND rownum = 1;
3908:

Line 4008: merged_uda_rec pos_supp_prof_ext_b%ROWTYPE;

4004: l_msg_count NUMBER;
4005: l_msg_data VARCHAR2(2000);
4006:
4007: l_uda_rec_tbl uda_rec_tbl_type;
4008: merged_uda_rec pos_supp_prof_ext_b%ROWTYPE;
4009: l_party_count NUMBER := 0;
4010: l_to_party_cntr NUMBER := 0;
4011:
4012: CURSOR get_supplier_attribute_groups IS

Line 4086: FROM pos_supp_prof_ext_b

4082: l_msg_data);
4083:
4084: SELECT COUNT(1)
4085: INTO l_party_count
4086: FROM pos_supp_prof_ext_b
4087: WHERE attr_group_id = attributes_group_coll(cntr).attr_group_id
4088: AND pk2_value = p_to_fk_id
4089: AND rownum = 1;
4090:

Line 4198: merged_uda_rec pos_supp_prof_ext_b%ROWTYPE;

4194: l_msg_count NUMBER;
4195: l_msg_data VARCHAR2(2000);
4196:
4197: l_uda_rec_tbl uda_rec_tbl_type;
4198: merged_uda_rec pos_supp_prof_ext_b%ROWTYPE;
4199: l_party_count NUMBER := 0;
4200: l_to_party_cntr NUMBER := 0;
4201:
4202: CURSOR get_supplier_attribute_groups IS

Line 4295: FROM pos_supp_prof_ext_b

4291: l_msg_data);
4292:
4293: SELECT COUNT(1)
4294: INTO l_party_count
4295: FROM pos_supp_prof_ext_b
4296: WHERE attr_group_id = attributes_group_coll(cntr).attr_group_id
4297: AND pk1_value = p_to_fk_id
4298: AND rownum = 1;
4299: