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.CS_SR_EXTATTRIBUTES_PVT dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 275: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;

271: )IS
272:
273: l_user_attr_data_table EGO_USER_ATTR_DATA_TABLE;
274: l_user_attr_row_table EGO_USER_ATTR_ROW_TABLE;
275: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
276: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
277: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
278: l_failed_row_id_list VARCHAR2(4000);
279: l_return_status VARCHAR2(1);

Line 276: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

272:
273: l_user_attr_data_table EGO_USER_ATTR_DATA_TABLE;
274: l_user_attr_row_table EGO_USER_ATTR_ROW_TABLE;
275: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
276: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
277: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
278: l_failed_row_id_list VARCHAR2(4000);
279: l_return_status VARCHAR2(1);
280: l_errorcode NUMBER;

Line 648: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM

644: --DBMS_OUTPUT.PUT_LINE ('Pass pk1 validation');
645:
646: -- If no error then
647: --Need to pass the incident_id to the ego object.
648: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM
649: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', p_ext_attr_grp_tbl(i).pk_column_1));
650:
651: --populate the new audit record simultanoeosly while populating the EGO record structure.
652: l_new_Ext_Attr_Audit_table(l_new_audit_count).pk_column_1 := p_ext_attr_grp_tbl(i).pk_column_1;

Line 649: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', p_ext_attr_grp_tbl(i).pk_column_1));

645:
646: -- If no error then
647: --Need to pass the incident_id to the ego object.
648: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM
649: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', p_ext_attr_grp_tbl(i).pk_column_1));
650:
651: --populate the new audit record simultanoeosly while populating the EGO record structure.
652: l_new_Ext_Attr_Audit_table(l_new_audit_count).pk_column_1 := p_ext_attr_grp_tbl(i).pk_column_1;
653:

Line 698: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.

694:
695: ELSE
696: --DBMS_OUTPUT.PUT_LINE('In else of context validation');
697: --context matches
698: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.
699: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', p_ext_attr_grp_tbl(i).context));
700:
701: --populate the new audit record for context.
702: l_new_Ext_Attr_Audit_table(l_new_audit_count).context := p_ext_attr_grp_tbl(i).context;

Line 699: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', p_ext_attr_grp_tbl(i).context));

695: ELSE
696: --DBMS_OUTPUT.PUT_LINE('In else of context validation');
697: --context matches
698: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.
699: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', p_ext_attr_grp_tbl(i).context));
700:
701: --populate the new audit record for context.
702: l_new_Ext_Attr_Audit_table(l_new_audit_count).context := p_ext_attr_grp_tbl(i).context;
703:

Line 1294: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM

1290: --DBMS_OUTPUT.PUT_LINE('v_get_old_context_value.attr_group_id'||v_get_old_context_value.attr_group_id);
1291:
1292: l_count := l_count + 1;
1293: --set the primary key identifiers to pass to PLM
1294: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM
1295: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY
1296: (EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', v_get_old_context_value.incident_id));
1297:
1298: --set the context to pass to PLM only SR_TYPE_ID

Line 1295: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY

1291:
1292: l_count := l_count + 1;
1293: --set the primary key identifiers to pass to PLM
1294: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM
1295: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY
1296: (EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', v_get_old_context_value.incident_id));
1297:
1298: --set the context to pass to PLM only SR_TYPE_ID
1299: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.

Line 1299: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.

1295: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY
1296: (EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', v_get_old_context_value.incident_id));
1297:
1298: --set the context to pass to PLM only SR_TYPE_ID
1299: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.
1300: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
1301: (EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', v_get_old_context_value.context));
1302:
1303: --Instanciate a new EGO_USER_ATTR_ROW_OBJ (only once)

Line 1300: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

1296: (EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', v_get_old_context_value.incident_id));
1297:
1298: --set the context to pass to PLM only SR_TYPE_ID
1299: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.
1300: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
1301: (EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', v_get_old_context_value.context));
1302:
1303: --Instanciate a new EGO_USER_ATTR_ROW_OBJ (only once)
1304: IF (l_user_attr_row_table IS NULL) THEN

Line 1503: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM

1499: END IF;
1500:
1501: -- If no error then
1502: --Need to set the composite primary key for the party role implementation.
1503: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM
1504:
1505: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', p_ext_attr_grp_tbl(i).pk_column_1),
1506: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', p_ext_attr_grp_tbl(i).pk_column_2),
1507: EGO_COL_NAME_VALUE_PAIR_OBJ('CONTACT_TYPE', p_ext_attr_grp_tbl(i).pk_column_3),

Line 1505: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', p_ext_attr_grp_tbl(i).pk_column_1),

1501: -- If no error then
1502: --Need to set the composite primary key for the party role implementation.
1503: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM
1504:
1505: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', p_ext_attr_grp_tbl(i).pk_column_1),
1506: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', p_ext_attr_grp_tbl(i).pk_column_2),
1507: EGO_COL_NAME_VALUE_PAIR_OBJ('CONTACT_TYPE', p_ext_attr_grp_tbl(i).pk_column_3),
1508: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ROLE_CODE', p_ext_attr_grp_tbl(i).pk_column_4));
1509:

Line 1510: --DBMS_OUTPUT.PUT_LINE('populated the EGO_COL_NAME_VALUE_PAIR_ARRAY');

1506: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', p_ext_attr_grp_tbl(i).pk_column_2),
1507: EGO_COL_NAME_VALUE_PAIR_OBJ('CONTACT_TYPE', p_ext_attr_grp_tbl(i).pk_column_3),
1508: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ROLE_CODE', p_ext_attr_grp_tbl(i).pk_column_4));
1509:
1510: --DBMS_OUTPUT.PUT_LINE('populated the EGO_COL_NAME_VALUE_PAIR_ARRAY');
1511: --populate the new audit record simultanoeosly while populating the EGO record structure.
1512: l_new_Ext_Attr_Audit_table(l_new_audit_count).pk_column_1 := p_ext_attr_grp_tbl(i).pk_column_1;
1513: l_new_Ext_Attr_Audit_table(l_new_audit_count).pk_column_2 := p_ext_attr_grp_tbl(i).pk_column_2;
1514: l_new_Ext_Attr_Audit_table(l_new_audit_count).pk_column_3 := p_ext_attr_grp_tbl(i).pk_column_3;

Line 1548: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.

1544: ELSE
1545:
1546: --DBMS_OUTPUT.PUT_LINE('context matches');
1547: --context matches
1548: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.
1549: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', p_ext_attr_grp_tbl(i).context));
1550:
1551: --DBMS_OUTPUT.PUT_LINE('populated EGO_COL_NAME_VALUE_PAIR_ARRAY');
1552:

Line 1549: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', p_ext_attr_grp_tbl(i).context));

1545:
1546: --DBMS_OUTPUT.PUT_LINE('context matches');
1547: --context matches
1548: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.
1549: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', p_ext_attr_grp_tbl(i).context));
1550:
1551: --DBMS_OUTPUT.PUT_LINE('populated EGO_COL_NAME_VALUE_PAIR_ARRAY');
1552:
1553: --populate the new audit record for context.

Line 1551: --DBMS_OUTPUT.PUT_LINE('populated EGO_COL_NAME_VALUE_PAIR_ARRAY');

1547: --context matches
1548: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.
1549: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', p_ext_attr_grp_tbl(i).context));
1550:
1551: --DBMS_OUTPUT.PUT_LINE('populated EGO_COL_NAME_VALUE_PAIR_ARRAY');
1552:
1553: --populate the new audit record for context.
1554: l_new_Ext_Attr_Audit_table(l_new_audit_count).context := p_ext_attr_grp_tbl(i).context;
1555:

Line 3969: l_pk_col_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;

3965: FROM cs_sr_contacts_ext
3966: WHERE extension_id = p_ext_id;
3967:
3968:
3969: l_pk_col_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
3970: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
3971: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
3972: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3973: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;

Line 4135: l_pk_col_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', to_char(p_incident_id)));

4131: );
4132: END IF;
4133:
4134: --populate the primary key array
4135: l_pk_col_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', to_char(p_incident_id)));
4136:
4137: --DBMS_OUTPUT.PUT_LINE('populated pk array');
4138:
4139: --get the attribute group information

Line 4475: l_pk_col_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', to_char(p_incident_id)),

4471: );
4472: END IF;
4473:
4474: --populate the primary key array
4475: l_pk_col_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', to_char(p_incident_id)),
4476: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', to_char(v_get_pr_ext_attr.party_id)),
4477: EGO_COL_NAME_VALUE_PAIR_OBJ('CONTACT_TYPE', v_get_pr_ext_attr.contact_type),
4478: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ROLE_CODE', v_get_pr_ext_attr.party_role_code));
4479:

Line 6794: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;

6790: , x_msg_count OUT NOCOPY NUMBER
6791: , x_msg_data OUT NOCOPY VARCHAR2
6792: ) IS
6793: --
6794: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
6795: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
6796: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
6797: l_user_attr_data_table EGO_USER_ATTR_DATA_TABLE;
6798: l_user_attr_row_table EGO_USER_ATTR_ROW_TABLE;

Line 6795: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

6791: , x_msg_data OUT NOCOPY VARCHAR2
6792: ) IS
6793: --
6794: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
6795: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
6796: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
6797: l_user_attr_data_table EGO_USER_ATTR_DATA_TABLE;
6798: l_user_attr_row_table EGO_USER_ATTR_ROW_TABLE;
6799: l_count NUMBER;

Line 6827: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM

6823: --DBMS_OUTPUT.PUT_LINE('v_get_old_context_value.attr_group_id'||v_get_old_context_value.attr_group_id);
6824:
6825: l_count := l_count + 1;
6826: --set the primary key identifiers to pass to PLM
6827: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM
6828: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY
6829: ( EGO_COL_NAME_VALUE_PAIR_OBJ
6830: ( 'INCIDENT_ID'
6831: , p_pk_column_1

Line 6828: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY

6824:
6825: l_count := l_count + 1;
6826: --set the primary key identifiers to pass to PLM
6827: --populating the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing primary key to PLM
6828: l_pk_name_value_pair := EGO_COL_NAME_VALUE_PAIR_ARRAY
6829: ( EGO_COL_NAME_VALUE_PAIR_OBJ
6830: ( 'INCIDENT_ID'
6831: , p_pk_column_1
6832: )

Line 6836: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.

6832: )
6833: );
6834:
6835: --set the context to pass to PLM only SR_TYPE_ID
6836: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.
6837: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
6838: ( EGO_COL_NAME_VALUE_PAIR_OBJ
6839: ( 'CONTEXT'
6840: , p_context

Line 6837: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

6833: );
6834:
6835: --set the context to pass to PLM only SR_TYPE_ID
6836: --populate the EGO_COL_NAME_VALUE_PAIR_ARRAY Array for passing the context.
6837: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
6838: ( EGO_COL_NAME_VALUE_PAIR_OBJ
6839: ( 'CONTEXT'
6840: , p_context
6841: )