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.MSC_CL_PRE_PROCESS dependencies on MSC_ST_PARTNER_CONTACTS

Line 1162: ||' on MSC_ST_PARTNER_CONTACTS '

1158: application_short_name => 'MSC',
1159: statement_type => AD_DDL.CREATE_INDEX,
1160: statement =>
1161: 'create index MSC_ST_PART_CONT_N1_'||v_instance_code
1162: ||' on MSC_ST_PARTNER_CONTACTS '
1163: ||'(sr_instance_code,tp_site_code, partner_name, partner_type, company_name) '
1164: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1165: object_name =>'MSC_ST_PART_CONT_N1_'||v_instance_code);
1166:

Line 1220: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PARTNER_CONTACTS', v_instance_id, -1);

1216: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNERS', v_instance_id, -1);
1217: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNER_SITES', v_instance_id, -1);
1218: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUB_INVENTORIES', v_instance_id, -1);
1219: msc_analyse_tables_pk.analyse_table( 'MSC_ST_LOCATION_ASSOCIATIONS', v_instance_id, -1);
1220: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PARTNER_CONTACTS', v_instance_id, -1);
1221:
1222: END IF;
1223:
1224: IF v_item_cst_enabled = SYS_YES THEN

Line 6326: FROM msc_st_partner_contacts

6322: GROUP BY location;
6323:
6324: CURSOR c8(p_batch_id NUMBER) IS
6325: SELECT rowid
6326: FROM msc_st_partner_contacts
6327: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
6328: AND sr_instance_code = v_instance_code
6329: AND batch_id = p_batch_id;
6330:

Line 9500: --Validation check for the table MSC_ST_PARTNER_CONTACTS

9496: IF lv_return <> 0 THEN
9497: RAISE ex_logging_err;
9498: END IF;
9499:
9500: --Validation check for the table MSC_ST_PARTNER_CONTACTS
9501:
9502: --Duplicate records check for the records whose source is other than XML
9503: --Different SQL is used because in XML we can identify the latest records
9504: --whereas in batch load we cannot.

Line 9508: 'UPDATE msc_st_partner_contacts mpc1 '

9504: --whereas in batch load we cannot.
9505:
9506: v_sql_stmt := 45;
9507: lv_sql_stmt :=
9508: 'UPDATE msc_st_partner_contacts mpc1 '
9509: ||' SET process_flag = '||G_ERROR_FLG||','
9510: ||' error_text = '||''''||lv_message_text||''''
9511: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_partner_contacts mpc2 '
9512: ||' WHERE mpc2.sr_instance_code = mpc1.sr_instance_code'

Line 9511: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_partner_contacts mpc2 '

9507: lv_sql_stmt :=
9508: 'UPDATE msc_st_partner_contacts mpc1 '
9509: ||' SET process_flag = '||G_ERROR_FLG||','
9510: ||' error_text = '||''''||lv_message_text||''''
9511: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_partner_contacts mpc2 '
9512: ||' WHERE mpc2.sr_instance_code = mpc1.sr_instance_code'
9513: ||' AND NVL(mpc2.company_name, '||''''||NULL_CHAR||''''||') = '
9514: ||' NVL(mpc1.company_name, '||''''||NULL_CHAR||''''||')'
9515: ||' AND mpc2.partner_name = mpc1.partner_name '

Line 9547: 'UPDATE msc_st_partner_contacts mpc1 '

9543:
9544: --Duplicate records check for the records whose source is XML
9545: v_sql_stmt := 46;
9546: lv_sql_stmt :=
9547: 'UPDATE msc_st_partner_contacts mpc1 '
9548: ||' SET process_flag = '||G_ERROR_FLG||','
9549: ||' error_text = '||''''||lv_message_text||''''
9550: ||' WHERE message_id < ( SELECT max(message_id) '
9551: ||' FROM msc_st_partner_contacts mpc2 '

Line 9551: ||' FROM msc_st_partner_contacts mpc2 '

9547: 'UPDATE msc_st_partner_contacts mpc1 '
9548: ||' SET process_flag = '||G_ERROR_FLG||','
9549: ||' error_text = '||''''||lv_message_text||''''
9550: ||' WHERE message_id < ( SELECT max(message_id) '
9551: ||' FROM msc_st_partner_contacts mpc2 '
9552: ||' WHERE mpc2.sr_instance_code = mpc1.sr_instance_code'
9553: ||' AND NVL(mpc2.company_name, '||''''||NULL_CHAR||''''||') = '
9554: ||' NVL(mpc1.company_name, '||''''||NULL_CHAR||''''||')'
9555: ||' AND mpc2.partner_name = mpc1.partner_name '

Line 9593: 'UPDATE msc_st_partner_contacts '

9589: FROM DUAL;
9590:
9591: v_sql_stmt := 48;
9592: lv_sql_stmt :=
9593: 'UPDATE msc_st_partner_contacts '
9594: ||' SET batch_id = :lv_batch_id '
9595: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
9596: ||' AND sr_instance_code = :v_instance_code'
9597: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 9615: UPDATE msc_st_partner_contacts

9611: CLOSE c8;
9612:
9613: v_sql_stmt := 49;
9614: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
9615: UPDATE msc_st_partner_contacts
9616: SET st_transaction_id = msc_st_partner_contacts_s.NEXTVAL,
9617: refresh_id = v_refresh_id,
9618: last_update_date = v_current_date,
9619: last_updated_by = v_current_user,

Line 9616: SET st_transaction_id = msc_st_partner_contacts_s.NEXTVAL,

9612:
9613: v_sql_stmt := 49;
9614: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
9615: UPDATE msc_st_partner_contacts
9616: SET st_transaction_id = msc_st_partner_contacts_s.NEXTVAL,
9617: refresh_id = v_refresh_id,
9618: last_update_date = v_current_date,
9619: last_updated_by = v_current_user,
9620: creation_date = v_current_date,

Line 9631: p_token_value1 => 'MSC_ST_PARTNER_CONTACTS');

9627: p_error_code => 'MSC_PP_NO_DELETION',
9628: p_message_text => lv_message_text,
9629: p_error_text => lv_error_text,
9630: p_token1 => 'TABLE_NAME',
9631: p_token_value1 => 'MSC_ST_PARTNER_CONTACTS');
9632:
9633: -- Deletion is not allowed for this table
9634: v_sql_stmt := 50;
9635: lv_sql_stmt :=

Line 9636: 'UPDATE msc_st_partner_contacts '

9632:
9633: -- Deletion is not allowed for this table
9634: v_sql_stmt := 50;
9635: lv_sql_stmt :=
9636: 'UPDATE msc_st_partner_contacts '
9637: ||' SET process_flag = '||G_ERROR_FLG||','
9638: ||' error_text = '||''''||lv_message_text||''''
9639: ||' WHERE deleted_flag = '||SYS_YES
9640: ||' AND process_flag = '||G_IN_PROCESS

Line 9676: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9672: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
9673: ||' NOT IN(1,2)';
9674:
9675: lv_return := MSC_ST_UTIL.LOG_ERROR
9676: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9677: p_instance_code => v_instance_code,
9678: p_row => lv_column_names,
9679: p_severity => G_SEV_WARNING,
9680: p_message_text => lv_message_text,

Line 9709: 'UPDATE msc_st_partner_contacts'

9705:
9706: -- Error out records where partner_name/tp_site_code/name is NULL
9707: v_sql_stmt := 51;
9708: lv_sql_stmt :=
9709: 'UPDATE msc_st_partner_contacts'
9710: ||' SET process_flag = '||G_ERROR_FLG||','
9711: ||' error_text = '||''''||lv_message_text||''''
9712: ||' WHERE (NVL(partner_name,'||''''||NULL_CHAR||''''||') '
9713: ||' = '||''''||NULL_CHAR||''''

Line 9745: 'UPDATE msc_st_partner_contacts'

9741:
9742: -- Error out records where partner_type NOT in (1,2)
9743: v_sql_stmt := 52;
9744: lv_sql_stmt :=
9745: 'UPDATE msc_st_partner_contacts'
9746: ||' SET process_flag = '||G_ERROR_FLG||','
9747: ||' error_text = '||''''||lv_message_text||''''
9748: ||' WHERE sr_instance_code = :v_instance_code'
9749: ||' AND batch_id = :lv_batch_id'

Line 9773: (p_table_name =>'MSC_ST_PARTNER_CONTACTS',

9769: END IF;
9770:
9771: -- Update sr_tp_id(customer)
9772: lv_return :=msc_st_util.derive_partner_org_id
9773: (p_table_name =>'MSC_ST_PARTNER_CONTACTS',
9774: p_org_partner_name =>'PARTNER_NAME',
9775: p_org_partner_id =>'PARTNER_ID',
9776: p_instance_code => v_instance_code,
9777: p_partner_type => G_CUSTOMER,

Line 9788: (p_table_name =>'MSC_ST_PARTNER_CONTACTS',

9784: END IF;
9785:
9786: -- Update sr_tp_id(supplier)
9787: lv_return :=msc_st_util.derive_partner_org_id
9788: (p_table_name =>'MSC_ST_PARTNER_CONTACTS',
9789: p_org_partner_name =>'PARTNER_NAME',
9790: p_org_partner_id =>'PARTNER_ID',
9791: p_instance_code => v_instance_code,
9792: p_partner_type => G_VENDOR,

Line 9817: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9813: END IF;
9814:
9815: -- Derive sr_tp_site_id(Customer)
9816: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
9817: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9818: p_partner_name => 'PARTNER_NAME',
9819: p_partner_site_code => 'TP_SITE_CODE',
9820: p_partner_site_id => 'PARTNER_SITE_ID',
9821: p_instance_code => v_instance_code,

Line 9834: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9830: END IF;
9831:
9832: -- Derive sr_tp_site_id(Supplier)
9833: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
9834: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9835: p_partner_name => 'PARTNER_NAME',
9836: p_partner_site_code => 'TP_SITE_CODE',
9837: p_partner_site_id => 'PARTNER_SITE_ID',
9838: p_instance_code => v_instance_code,

Line 9857: pEntityName => 'MSC_ST_PARTNER_CONTACTS',

9853: (ERRBUF => lv_error_text,
9854: RETCODE => lv_return,
9855: pBatchID => lv_batch_id,
9856: pInstanceCode => v_instance_code,
9857: pEntityName => 'MSC_ST_PARTNER_CONTACTS',
9858: pInstanceID => v_instance_id);
9859:
9860: IF NVL(lv_return,0) <> 0 THEN
9861: RAISE ex_logging_err;

Line 9866: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9862: END IF;
9863:
9864: -- Set the process flag as Valid and populate instance_id
9865: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
9866: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9867: p_instance_id => v_instance_id,
9868: p_instance_code => v_instance_code,
9869: p_process_flag => G_VALID,
9870: p_error_text => lv_error_text,

Line 9881: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9877:
9878: -- At the end calling the LOG_ERROR for logging all
9879: -- errored out records.
9880: lv_return := MSC_ST_UTIL.LOG_ERROR
9881: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9882: p_instance_code => v_instance_code,
9883: p_row => lv_column_names,
9884: p_severity => G_SEV_ERROR,
9885: p_message_text => NULL,

Line 55925: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_PARTNER_CONTACTS');

55921: IF lv_count > 0 Then
55922: prec.tp_customer_flag:= SYS_YES;
55923: prec.tp_vendor_flag:= SYS_YES;
55924: End IF;
55925: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_PARTNER_CONTACTS');
55926: IF lv_count > 0 Then
55927: prec.tp_customer_flag:= SYS_YES;
55928: prec.tp_vendor_flag:= SYS_YES;
55929: End IF;