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_OBJ

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 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 1296: (EGO_COL_NAME_VALUE_PAIR_OBJ('INCIDENT_ID', v_get_old_context_value.incident_id));

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.
1300: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 1301: (EGO_COL_NAME_VALUE_PAIR_OBJ('CONTEXT', v_get_old_context_value.context));

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
1305: l_user_attr_row_table := EGO_USER_ATTR_ROW_TABLE();

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 1506: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', p_ext_attr_grp_tbl(i).pk_column_2),

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:
1510: --DBMS_OUTPUT.PUT_LINE('populated the EGO_COL_NAME_VALUE_PAIR_ARRAY');

Line 1507: EGO_COL_NAME_VALUE_PAIR_OBJ('CONTACT_TYPE', p_ext_attr_grp_tbl(i).pk_column_3),

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:
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.

Line 1508: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ROLE_CODE', p_ext_attr_grp_tbl(i).pk_column_4));

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:
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;

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 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 4476: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', to_char(v_get_pr_ext_attr.party_id)),

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:
4480: --get the attribute group information

Line 4477: EGO_COL_NAME_VALUE_PAIR_OBJ('CONTACT_TYPE', v_get_pr_ext_attr.contact_type),

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:
4480: --get the attribute group information
4481: IF v_get_pr_ext_attr.attr_group_id IS NOT NULL then

Line 4478: EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ROLE_CODE', v_get_pr_ext_attr.party_role_code));

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:
4480: --get the attribute group information
4481: IF v_get_pr_ext_attr.attr_group_id IS NOT NULL then
4482: --get the attribute group type name and appl id

Line 6829: ( EGO_COL_NAME_VALUE_PAIR_OBJ

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: )
6833: );

Line 6838: ( EGO_COL_NAME_VALUE_PAIR_OBJ

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: )
6842: );