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.

[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_PARTNER_CONTACTS

Line 1154: ||' on MSC_ST_PARTNER_CONTACTS '

1150: application_short_name => 'MSC',
1151: statement_type => AD_DDL.CREATE_INDEX,
1152: statement =>
1153: 'create index MSC_ST_PART_CONT_N1_'||v_instance_code
1154: ||' on MSC_ST_PARTNER_CONTACTS '
1155: ||'(sr_instance_code,tp_site_code, partner_name, partner_type, company_name) '
1156: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1157: object_name =>'MSC_ST_PART_CONT_N1_'||v_instance_code);
1158:

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

1208: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNERS', v_instance_id, -1);
1209: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNER_SITES', v_instance_id, -1);
1210: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUB_INVENTORIES', v_instance_id, -1);
1211: msc_analyse_tables_pk.analyse_table( 'MSC_ST_LOCATION_ASSOCIATIONS', v_instance_id, -1);
1212: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PARTNER_CONTACTS', v_instance_id, -1);
1213:
1214: END IF;
1215:
1216: IF v_item_cst_enabled = SYS_YES THEN

Line 6319: FROM msc_st_partner_contacts

6315: GROUP BY location;
6316:
6317: CURSOR c8(p_batch_id NUMBER) IS
6318: SELECT rowid
6319: FROM msc_st_partner_contacts
6320: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
6321: AND sr_instance_code = v_instance_code
6322: AND batch_id = p_batch_id;
6323:

Line 9374: --Validation check for the table MSC_ST_PARTNER_CONTACTS

9370: IF lv_return <> 0 THEN
9371: RAISE ex_logging_err;
9372: END IF;
9373:
9374: --Validation check for the table MSC_ST_PARTNER_CONTACTS
9375:
9376: --Duplicate records check for the records whose source is other than XML
9377: --Different SQL is used because in XML we can identify the latest records
9378: --whereas in batch load we cannot.

Line 9382: 'UPDATE msc_st_partner_contacts mpc1 '

9378: --whereas in batch load we cannot.
9379:
9380: v_sql_stmt := 45;
9381: lv_sql_stmt :=
9382: 'UPDATE msc_st_partner_contacts mpc1 '
9383: ||' SET process_flag = '||G_ERROR_FLG||','
9384: ||' error_text = '||''''||lv_message_text||''''
9385: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_partner_contacts mpc2 '
9386: ||' WHERE mpc2.sr_instance_code = mpc1.sr_instance_code'

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

9381: lv_sql_stmt :=
9382: 'UPDATE msc_st_partner_contacts mpc1 '
9383: ||' SET process_flag = '||G_ERROR_FLG||','
9384: ||' error_text = '||''''||lv_message_text||''''
9385: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_partner_contacts mpc2 '
9386: ||' WHERE mpc2.sr_instance_code = mpc1.sr_instance_code'
9387: ||' AND NVL(mpc2.company_name, '||''''||NULL_CHAR||''''||') = '
9388: ||' NVL(mpc1.company_name, '||''''||NULL_CHAR||''''||')'
9389: ||' AND mpc2.partner_name = mpc1.partner_name '

Line 9421: 'UPDATE msc_st_partner_contacts mpc1 '

9417:
9418: --Duplicate records check for the records whose source is XML
9419: v_sql_stmt := 46;
9420: lv_sql_stmt :=
9421: 'UPDATE msc_st_partner_contacts mpc1 '
9422: ||' SET process_flag = '||G_ERROR_FLG||','
9423: ||' error_text = '||''''||lv_message_text||''''
9424: ||' WHERE message_id < ( SELECT max(message_id) '
9425: ||' FROM msc_st_partner_contacts mpc2 '

Line 9425: ||' FROM msc_st_partner_contacts mpc2 '

9421: 'UPDATE msc_st_partner_contacts mpc1 '
9422: ||' SET process_flag = '||G_ERROR_FLG||','
9423: ||' error_text = '||''''||lv_message_text||''''
9424: ||' WHERE message_id < ( SELECT max(message_id) '
9425: ||' FROM msc_st_partner_contacts mpc2 '
9426: ||' WHERE mpc2.sr_instance_code = mpc1.sr_instance_code'
9427: ||' AND NVL(mpc2.company_name, '||''''||NULL_CHAR||''''||') = '
9428: ||' NVL(mpc1.company_name, '||''''||NULL_CHAR||''''||')'
9429: ||' AND mpc2.partner_name = mpc1.partner_name '

Line 9467: 'UPDATE msc_st_partner_contacts '

9463: FROM DUAL;
9464:
9465: v_sql_stmt := 48;
9466: lv_sql_stmt :=
9467: 'UPDATE msc_st_partner_contacts '
9468: ||' SET batch_id = :lv_batch_id '
9469: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
9470: ||' AND sr_instance_code = :v_instance_code'
9471: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 9489: UPDATE msc_st_partner_contacts

9485: CLOSE c8;
9486:
9487: v_sql_stmt := 49;
9488: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
9489: UPDATE msc_st_partner_contacts
9490: SET st_transaction_id = msc_st_partner_contacts_s.NEXTVAL,
9491: refresh_id = v_refresh_id,
9492: last_update_date = v_current_date,
9493: last_updated_by = v_current_user,

Line 9490: SET st_transaction_id = msc_st_partner_contacts_s.NEXTVAL,

9486:
9487: v_sql_stmt := 49;
9488: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
9489: UPDATE msc_st_partner_contacts
9490: SET st_transaction_id = msc_st_partner_contacts_s.NEXTVAL,
9491: refresh_id = v_refresh_id,
9492: last_update_date = v_current_date,
9493: last_updated_by = v_current_user,
9494: creation_date = v_current_date,

Line 9505: p_token_value1 => 'MSC_ST_PARTNER_CONTACTS');

9501: p_error_code => 'MSC_PP_NO_DELETION',
9502: p_message_text => lv_message_text,
9503: p_error_text => lv_error_text,
9504: p_token1 => 'TABLE_NAME',
9505: p_token_value1 => 'MSC_ST_PARTNER_CONTACTS');
9506:
9507: -- Deletion is not allowed for this table
9508: v_sql_stmt := 50;
9509: lv_sql_stmt :=

Line 9510: 'UPDATE msc_st_partner_contacts '

9506:
9507: -- Deletion is not allowed for this table
9508: v_sql_stmt := 50;
9509: lv_sql_stmt :=
9510: 'UPDATE msc_st_partner_contacts '
9511: ||' SET process_flag = '||G_ERROR_FLG||','
9512: ||' error_text = '||''''||lv_message_text||''''
9513: ||' WHERE deleted_flag = '||SYS_YES
9514: ||' AND process_flag = '||G_IN_PROCESS

Line 9550: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9546: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
9547: ||' NOT IN(1,2)';
9548:
9549: lv_return := MSC_ST_UTIL.LOG_ERROR
9550: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9551: p_instance_code => v_instance_code,
9552: p_row => lv_column_names,
9553: p_severity => G_SEV_WARNING,
9554: p_message_text => lv_message_text,

Line 9583: 'UPDATE msc_st_partner_contacts'

9579:
9580: -- Error out records where partner_name/tp_site_code/name is NULL
9581: v_sql_stmt := 51;
9582: lv_sql_stmt :=
9583: 'UPDATE msc_st_partner_contacts'
9584: ||' SET process_flag = '||G_ERROR_FLG||','
9585: ||' error_text = '||''''||lv_message_text||''''
9586: ||' WHERE (NVL(partner_name,'||''''||NULL_CHAR||''''||') '
9587: ||' = '||''''||NULL_CHAR||''''

Line 9619: 'UPDATE msc_st_partner_contacts'

9615:
9616: -- Error out records where partner_type NOT in (1,2)
9617: v_sql_stmt := 52;
9618: lv_sql_stmt :=
9619: 'UPDATE msc_st_partner_contacts'
9620: ||' SET process_flag = '||G_ERROR_FLG||','
9621: ||' error_text = '||''''||lv_message_text||''''
9622: ||' WHERE sr_instance_code = :v_instance_code'
9623: ||' AND batch_id = :lv_batch_id'

Line 9647: (p_table_name =>'MSC_ST_PARTNER_CONTACTS',

9643: END IF;
9644:
9645: -- Update sr_tp_id(customer)
9646: lv_return :=msc_st_util.derive_partner_org_id
9647: (p_table_name =>'MSC_ST_PARTNER_CONTACTS',
9648: p_org_partner_name =>'PARTNER_NAME',
9649: p_org_partner_id =>'PARTNER_ID',
9650: p_instance_code => v_instance_code,
9651: p_partner_type => G_CUSTOMER,

Line 9662: (p_table_name =>'MSC_ST_PARTNER_CONTACTS',

9658: END IF;
9659:
9660: -- Update sr_tp_id(supplier)
9661: lv_return :=msc_st_util.derive_partner_org_id
9662: (p_table_name =>'MSC_ST_PARTNER_CONTACTS',
9663: p_org_partner_name =>'PARTNER_NAME',
9664: p_org_partner_id =>'PARTNER_ID',
9665: p_instance_code => v_instance_code,
9666: p_partner_type => G_VENDOR,

Line 9691: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9687: END IF;
9688:
9689: -- Derive sr_tp_site_id(Customer)
9690: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
9691: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9692: p_partner_name => 'PARTNER_NAME',
9693: p_partner_site_code => 'TP_SITE_CODE',
9694: p_partner_site_id => 'PARTNER_SITE_ID',
9695: p_instance_code => v_instance_code,

Line 9708: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9704: END IF;
9705:
9706: -- Derive sr_tp_site_id(Supplier)
9707: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
9708: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9709: p_partner_name => 'PARTNER_NAME',
9710: p_partner_site_code => 'TP_SITE_CODE',
9711: p_partner_site_id => 'PARTNER_SITE_ID',
9712: p_instance_code => v_instance_code,

Line 9731: pEntityName => 'MSC_ST_PARTNER_CONTACTS',

9727: (ERRBUF => lv_error_text,
9728: RETCODE => lv_return,
9729: pBatchID => lv_batch_id,
9730: pInstanceCode => v_instance_code,
9731: pEntityName => 'MSC_ST_PARTNER_CONTACTS',
9732: pInstanceID => v_instance_id);
9733:
9734: IF NVL(lv_return,0) <> 0 THEN
9735: RAISE ex_logging_err;

Line 9740: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9736: END IF;
9737:
9738: -- Set the process flag as Valid and populate instance_id
9739: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
9740: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9741: p_instance_id => v_instance_id,
9742: p_instance_code => v_instance_code,
9743: p_process_flag => G_VALID,
9744: p_error_text => lv_error_text,

Line 9755: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',

9751:
9752: -- At the end calling the LOG_ERROR for logging all
9753: -- errored out records.
9754: lv_return := MSC_ST_UTIL.LOG_ERROR
9755: (p_table_name => 'MSC_ST_PARTNER_CONTACTS',
9756: p_instance_code => v_instance_code,
9757: p_row => lv_column_names,
9758: p_severity => G_SEV_ERROR,
9759: p_message_text => NULL,

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

50999: IF lv_count > 0 Then
51000: prec.tp_customer_flag:= SYS_YES;
51001: prec.tp_vendor_flag:= SYS_YES;
51002: End IF;
51003: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_PARTNER_CONTACTS');
51004: IF lv_count > 0 Then
51005: prec.tp_customer_flag:= SYS_YES;
51006: prec.tp_vendor_flag:= SYS_YES;
51007: End IF;