565: ) IS
566:
567: BEGIN
568:
569: dbms_sql.column_value(p_get_acct_cursor_id, 1, x_pty_acct_query_rec.ip_account_id);
570: dbms_sql.column_value(p_get_acct_cursor_id, 2, x_pty_acct_query_rec.instance_party_id);
571: dbms_sql.column_value(p_get_acct_cursor_id, 3, x_pty_acct_query_rec.party_account_id);
572: dbms_sql.column_value(p_get_acct_cursor_id, 4, x_pty_acct_query_rec.relationship_type_code );
573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);
566:
567: BEGIN
568:
569: dbms_sql.column_value(p_get_acct_cursor_id, 1, x_pty_acct_query_rec.ip_account_id);
570: dbms_sql.column_value(p_get_acct_cursor_id, 2, x_pty_acct_query_rec.instance_party_id);
571: dbms_sql.column_value(p_get_acct_cursor_id, 3, x_pty_acct_query_rec.party_account_id);
572: dbms_sql.column_value(p_get_acct_cursor_id, 4, x_pty_acct_query_rec.relationship_type_code );
573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);
574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);
567: BEGIN
568:
569: dbms_sql.column_value(p_get_acct_cursor_id, 1, x_pty_acct_query_rec.ip_account_id);
570: dbms_sql.column_value(p_get_acct_cursor_id, 2, x_pty_acct_query_rec.instance_party_id);
571: dbms_sql.column_value(p_get_acct_cursor_id, 3, x_pty_acct_query_rec.party_account_id);
572: dbms_sql.column_value(p_get_acct_cursor_id, 4, x_pty_acct_query_rec.relationship_type_code );
573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);
574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);
575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);
568:
569: dbms_sql.column_value(p_get_acct_cursor_id, 1, x_pty_acct_query_rec.ip_account_id);
570: dbms_sql.column_value(p_get_acct_cursor_id, 2, x_pty_acct_query_rec.instance_party_id);
571: dbms_sql.column_value(p_get_acct_cursor_id, 3, x_pty_acct_query_rec.party_account_id);
572: dbms_sql.column_value(p_get_acct_cursor_id, 4, x_pty_acct_query_rec.relationship_type_code );
573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);
574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);
575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);
576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);
569: dbms_sql.column_value(p_get_acct_cursor_id, 1, x_pty_acct_query_rec.ip_account_id);
570: dbms_sql.column_value(p_get_acct_cursor_id, 2, x_pty_acct_query_rec.instance_party_id);
571: dbms_sql.column_value(p_get_acct_cursor_id, 3, x_pty_acct_query_rec.party_account_id);
572: dbms_sql.column_value(p_get_acct_cursor_id, 4, x_pty_acct_query_rec.relationship_type_code );
573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);
574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);
575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);
576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);
577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);
570: dbms_sql.column_value(p_get_acct_cursor_id, 2, x_pty_acct_query_rec.instance_party_id);
571: dbms_sql.column_value(p_get_acct_cursor_id, 3, x_pty_acct_query_rec.party_account_id);
572: dbms_sql.column_value(p_get_acct_cursor_id, 4, x_pty_acct_query_rec.relationship_type_code );
573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);
574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);
575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);
576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);
577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);
578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);
571: dbms_sql.column_value(p_get_acct_cursor_id, 3, x_pty_acct_query_rec.party_account_id);
572: dbms_sql.column_value(p_get_acct_cursor_id, 4, x_pty_acct_query_rec.relationship_type_code );
573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);
574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);
575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);
576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);
577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);
578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);
579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);
572: dbms_sql.column_value(p_get_acct_cursor_id, 4, x_pty_acct_query_rec.relationship_type_code );
573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);
574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);
575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);
576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);
577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);
578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);
579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);
580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);
573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);
574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);
575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);
576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);
577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);
578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);
579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);
580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);
581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);
574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);
575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);
576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);
577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);
578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);
579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);
580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);
581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);
582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);
575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);
576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);
577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);
578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);
579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);
580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);
581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);
582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);
583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);
576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);
577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);
578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);
579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);
580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);
581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);
582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);
583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);
584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);
577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);
578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);
579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);
580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);
581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);
582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);
583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);
584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);
585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);
578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);
579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);
580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);
581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);
582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);
583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);
584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);
585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);
586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);
579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);
580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);
581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);
582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);
583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);
584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);
585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);
586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);
587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);
580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);
581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);
582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);
583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);
584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);
585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);
586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);
587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);
588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);
581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);
582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);
583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);
584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);
585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);
586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);
587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);
588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);
589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);
582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);
583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);
584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);
585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);
586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);
587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);
588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);
589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);
590: dbms_sql.column_value(p_get_acct_cursor_id, 22, x_pty_acct_query_rec.attribute15);
583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);
584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);
585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);
586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);
587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);
588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);
589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);
590: dbms_sql.column_value(p_get_acct_cursor_id, 22, x_pty_acct_query_rec.attribute15);
591: dbms_sql.column_value(p_get_acct_cursor_id, 23, x_pty_acct_query_rec.object_version_number);
584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);
585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);
586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);
587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);
588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);
589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);
590: dbms_sql.column_value(p_get_acct_cursor_id, 22, x_pty_acct_query_rec.attribute15);
591: dbms_sql.column_value(p_get_acct_cursor_id, 23, x_pty_acct_query_rec.object_version_number);
592: dbms_sql.column_value(p_get_acct_cursor_id, 24, x_pty_acct_query_rec.bill_to_address);
585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);
586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);
587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);
588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);
589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);
590: dbms_sql.column_value(p_get_acct_cursor_id, 22, x_pty_acct_query_rec.attribute15);
591: dbms_sql.column_value(p_get_acct_cursor_id, 23, x_pty_acct_query_rec.object_version_number);
592: dbms_sql.column_value(p_get_acct_cursor_id, 24, x_pty_acct_query_rec.bill_to_address);
593: dbms_sql.column_value(p_get_acct_cursor_id, 25, x_pty_acct_query_rec.ship_to_address);
586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);
587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);
588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);
589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);
590: dbms_sql.column_value(p_get_acct_cursor_id, 22, x_pty_acct_query_rec.attribute15);
591: dbms_sql.column_value(p_get_acct_cursor_id, 23, x_pty_acct_query_rec.object_version_number);
592: dbms_sql.column_value(p_get_acct_cursor_id, 24, x_pty_acct_query_rec.bill_to_address);
593: dbms_sql.column_value(p_get_acct_cursor_id, 25, x_pty_acct_query_rec.ship_to_address);
594:
587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);
588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);
589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);
590: dbms_sql.column_value(p_get_acct_cursor_id, 22, x_pty_acct_query_rec.attribute15);
591: dbms_sql.column_value(p_get_acct_cursor_id, 23, x_pty_acct_query_rec.object_version_number);
592: dbms_sql.column_value(p_get_acct_cursor_id, 24, x_pty_acct_query_rec.bill_to_address);
593: dbms_sql.column_value(p_get_acct_cursor_id, 25, x_pty_acct_query_rec.ship_to_address);
594:
595: END Get_acct_Column_Values;
588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);
589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);
590: dbms_sql.column_value(p_get_acct_cursor_id, 22, x_pty_acct_query_rec.attribute15);
591: dbms_sql.column_value(p_get_acct_cursor_id, 23, x_pty_acct_query_rec.object_version_number);
592: dbms_sql.column_value(p_get_acct_cursor_id, 24, x_pty_acct_query_rec.bill_to_address);
593: dbms_sql.column_value(p_get_acct_cursor_id, 25, x_pty_acct_query_rec.ship_to_address);
594:
595: END Get_acct_Column_Values;
596:
589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);
590: dbms_sql.column_value(p_get_acct_cursor_id, 22, x_pty_acct_query_rec.attribute15);
591: dbms_sql.column_value(p_get_acct_cursor_id, 23, x_pty_acct_query_rec.object_version_number);
592: dbms_sql.column_value(p_get_acct_cursor_id, 24, x_pty_acct_query_rec.bill_to_address);
593: dbms_sql.column_value(p_get_acct_cursor_id, 25, x_pty_acct_query_rec.ship_to_address);
594:
595: END Get_acct_Column_Values;
596:
597: /*----------------------------------------------------------*/
606: ) IS
607: l_party_acct_rec csi_datastructures_pub.party_account_header_rec;
608: BEGIN
609:
610: dbms_sql.define_column(p_get_acct_cursor_id, 1, l_party_acct_rec.ip_account_id);
611: dbms_sql.define_column(p_get_acct_cursor_id, 2, l_party_acct_rec.instance_party_id);
612: dbms_sql.define_column(p_get_acct_cursor_id, 3, l_party_acct_rec.party_account_id);
613: dbms_sql.define_column(p_get_acct_cursor_id, 4, l_party_acct_rec.relationship_type_code ,30);
614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);
607: l_party_acct_rec csi_datastructures_pub.party_account_header_rec;
608: BEGIN
609:
610: dbms_sql.define_column(p_get_acct_cursor_id, 1, l_party_acct_rec.ip_account_id);
611: dbms_sql.define_column(p_get_acct_cursor_id, 2, l_party_acct_rec.instance_party_id);
612: dbms_sql.define_column(p_get_acct_cursor_id, 3, l_party_acct_rec.party_account_id);
613: dbms_sql.define_column(p_get_acct_cursor_id, 4, l_party_acct_rec.relationship_type_code ,30);
614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);
615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);
608: BEGIN
609:
610: dbms_sql.define_column(p_get_acct_cursor_id, 1, l_party_acct_rec.ip_account_id);
611: dbms_sql.define_column(p_get_acct_cursor_id, 2, l_party_acct_rec.instance_party_id);
612: dbms_sql.define_column(p_get_acct_cursor_id, 3, l_party_acct_rec.party_account_id);
613: dbms_sql.define_column(p_get_acct_cursor_id, 4, l_party_acct_rec.relationship_type_code ,30);
614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);
615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);
616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);
609:
610: dbms_sql.define_column(p_get_acct_cursor_id, 1, l_party_acct_rec.ip_account_id);
611: dbms_sql.define_column(p_get_acct_cursor_id, 2, l_party_acct_rec.instance_party_id);
612: dbms_sql.define_column(p_get_acct_cursor_id, 3, l_party_acct_rec.party_account_id);
613: dbms_sql.define_column(p_get_acct_cursor_id, 4, l_party_acct_rec.relationship_type_code ,30);
614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);
615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);
616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);
617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,150);
610: dbms_sql.define_column(p_get_acct_cursor_id, 1, l_party_acct_rec.ip_account_id);
611: dbms_sql.define_column(p_get_acct_cursor_id, 2, l_party_acct_rec.instance_party_id);
612: dbms_sql.define_column(p_get_acct_cursor_id, 3, l_party_acct_rec.party_account_id);
613: dbms_sql.define_column(p_get_acct_cursor_id, 4, l_party_acct_rec.relationship_type_code ,30);
614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);
615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);
616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);
617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,150);
618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,150);
611: dbms_sql.define_column(p_get_acct_cursor_id, 2, l_party_acct_rec.instance_party_id);
612: dbms_sql.define_column(p_get_acct_cursor_id, 3, l_party_acct_rec.party_account_id);
613: dbms_sql.define_column(p_get_acct_cursor_id, 4, l_party_acct_rec.relationship_type_code ,30);
614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);
615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);
616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);
617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,150);
618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,150);
619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,150);
612: dbms_sql.define_column(p_get_acct_cursor_id, 3, l_party_acct_rec.party_account_id);
613: dbms_sql.define_column(p_get_acct_cursor_id, 4, l_party_acct_rec.relationship_type_code ,30);
614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);
615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);
616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);
617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,150);
618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,150);
619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,150);
620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,150);
613: dbms_sql.define_column(p_get_acct_cursor_id, 4, l_party_acct_rec.relationship_type_code ,30);
614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);
615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);
616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);
617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,150);
618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,150);
619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,150);
620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,150);
621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,150);
614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);
615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);
616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);
617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,150);
618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,150);
619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,150);
620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,150);
621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,150);
622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,150);
615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);
616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);
617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,150);
618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,150);
619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,150);
620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,150);
621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,150);
622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,150);
623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,150);
616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);
617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,150);
618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,150);
619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,150);
620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,150);
621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,150);
622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,150);
623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,150);
624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,150);
617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,150);
618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,150);
619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,150);
620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,150);
621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,150);
622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,150);
623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,150);
624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,150);
625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,150);
618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,150);
619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,150);
620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,150);
621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,150);
622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,150);
623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,150);
624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,150);
625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,150);
626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,150);
619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,150);
620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,150);
621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,150);
622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,150);
623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,150);
624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,150);
625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,150);
626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,150);
627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,150);
620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,150);
621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,150);
622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,150);
623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,150);
624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,150);
625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,150);
626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,150);
627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,150);
628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,150);
621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,150);
622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,150);
623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,150);
624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,150);
625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,150);
626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,150);
627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,150);
628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,150);
629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,150);
622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,150);
623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,150);
624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,150);
625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,150);
626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,150);
627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,150);
628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,150);
629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,150);
630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,150);
623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,150);
624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,150);
625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,150);
626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,150);
627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,150);
628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,150);
629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,150);
630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,150);
631: dbms_sql.define_column(p_get_acct_cursor_id, 22, l_party_acct_rec.attribute15,150);
624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,150);
625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,150);
626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,150);
627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,150);
628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,150);
629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,150);
630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,150);
631: dbms_sql.define_column(p_get_acct_cursor_id, 22, l_party_acct_rec.attribute15,150);
632: dbms_sql.define_column(p_get_acct_cursor_id, 23, l_party_acct_rec.object_version_number);
625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,150);
626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,150);
627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,150);
628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,150);
629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,150);
630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,150);
631: dbms_sql.define_column(p_get_acct_cursor_id, 22, l_party_acct_rec.attribute15,150);
632: dbms_sql.define_column(p_get_acct_cursor_id, 23, l_party_acct_rec.object_version_number);
633: dbms_sql.define_column(p_get_acct_cursor_id, 24, l_party_acct_rec.bill_to_address);
626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,150);
627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,150);
628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,150);
629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,150);
630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,150);
631: dbms_sql.define_column(p_get_acct_cursor_id, 22, l_party_acct_rec.attribute15,150);
632: dbms_sql.define_column(p_get_acct_cursor_id, 23, l_party_acct_rec.object_version_number);
633: dbms_sql.define_column(p_get_acct_cursor_id, 24, l_party_acct_rec.bill_to_address);
634: dbms_sql.define_column(p_get_acct_cursor_id, 25, l_party_acct_rec.ship_to_address);
627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,150);
628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,150);
629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,150);
630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,150);
631: dbms_sql.define_column(p_get_acct_cursor_id, 22, l_party_acct_rec.attribute15,150);
632: dbms_sql.define_column(p_get_acct_cursor_id, 23, l_party_acct_rec.object_version_number);
633: dbms_sql.define_column(p_get_acct_cursor_id, 24, l_party_acct_rec.bill_to_address);
634: dbms_sql.define_column(p_get_acct_cursor_id, 25, l_party_acct_rec.ship_to_address);
635:
628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,150);
629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,150);
630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,150);
631: dbms_sql.define_column(p_get_acct_cursor_id, 22, l_party_acct_rec.attribute15,150);
632: dbms_sql.define_column(p_get_acct_cursor_id, 23, l_party_acct_rec.object_version_number);
633: dbms_sql.define_column(p_get_acct_cursor_id, 24, l_party_acct_rec.bill_to_address);
634: dbms_sql.define_column(p_get_acct_cursor_id, 25, l_party_acct_rec.ship_to_address);
635:
636: END Define_Acct_Columns;
629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,150);
630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,150);
631: dbms_sql.define_column(p_get_acct_cursor_id, 22, l_party_acct_rec.attribute15,150);
632: dbms_sql.define_column(p_get_acct_cursor_id, 23, l_party_acct_rec.object_version_number);
633: dbms_sql.define_column(p_get_acct_cursor_id, 24, l_party_acct_rec.bill_to_address);
634: dbms_sql.define_column(p_get_acct_cursor_id, 25, l_party_acct_rec.ship_to_address);
635:
636: END Define_Acct_Columns;
637:
630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,150);
631: dbms_sql.define_column(p_get_acct_cursor_id, 22, l_party_acct_rec.attribute15,150);
632: dbms_sql.define_column(p_get_acct_cursor_id, 23, l_party_acct_rec.object_version_number);
633: dbms_sql.define_column(p_get_acct_cursor_id, 24, l_party_acct_rec.bill_to_address);
634: dbms_sql.define_column(p_get_acct_cursor_id, 25, l_party_acct_rec.ship_to_address);
635:
636: END Define_Acct_Columns;
637:
638:
650:
651: BEGIN
652: IF( (p_pty_acct_query_rec.ip_account_id IS NOT NULL)
653: AND (p_pty_acct_query_rec.ip_account_id <> FND_API.G_MISS_NUM)) THEN
654: DBMS_SQL.BIND_VARIABLE(p_get_acct_cursor_id, ':ip_account_id', p_pty_acct_query_rec.ip_account_id);
655: END IF;
656:
657: IF( (p_pty_acct_query_rec.instance_party_id IS NOT NULL)
658: AND (p_pty_acct_query_rec.instance_party_id <> FND_API.G_MISS_NUM)) THEN
655: END IF;
656:
657: IF( (p_pty_acct_query_rec.instance_party_id IS NOT NULL)
658: AND (p_pty_acct_query_rec.instance_party_id <> FND_API.G_MISS_NUM)) THEN
659: DBMS_SQL.BIND_VARIABLE(p_get_acct_cursor_id, ':instance_party_id', p_pty_acct_query_rec.instance_party_id);
660: END IF;
661:
662: IF( (p_pty_acct_query_rec.party_account_id IS NOT NULL)
663: AND (p_pty_acct_query_rec.party_account_id <> FND_API.G_MISS_NUM)) THEN
660: END IF;
661:
662: IF( (p_pty_acct_query_rec.party_account_id IS NOT NULL)
663: AND (p_pty_acct_query_rec.party_account_id <> FND_API.G_MISS_NUM)) THEN
664: DBMS_SQL.BIND_VARIABLE(p_get_acct_cursor_id, ':party_account_id', p_pty_acct_query_rec.party_account_id);
665: END IF;
666:
667: IF( (p_pty_acct_query_rec.relationship_type_code IS NOT NULL)
668: AND (p_pty_acct_query_rec.relationship_type_code <> FND_API.G_MISS_CHAR)) THEN
665: END IF;
666:
667: IF( (p_pty_acct_query_rec.relationship_type_code IS NOT NULL)
668: AND (p_pty_acct_query_rec.relationship_type_code <> FND_API.G_MISS_CHAR)) THEN
669: DBMS_SQL.BIND_VARIABLE(p_get_acct_cursor_id, ':relationship_type_code', p_pty_acct_query_rec.relationship_type_code);
670: END IF;
671:
672: END ;
673:
1226: ) IS
1227:
1228: BEGIN
1229:
1230: dbms_sql.column_value(p_get_pty_cursor_id, 1, x_party_rec.instance_party_id);
1231: dbms_sql.column_value(p_get_pty_cursor_id, 2, x_party_rec.instance_id);
1232: dbms_sql.column_value(p_get_pty_cursor_id, 3, x_party_rec.party_source_table);
1233: dbms_sql.column_value(p_get_pty_cursor_id, 4, x_party_rec.party_id);
1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);
1227:
1228: BEGIN
1229:
1230: dbms_sql.column_value(p_get_pty_cursor_id, 1, x_party_rec.instance_party_id);
1231: dbms_sql.column_value(p_get_pty_cursor_id, 2, x_party_rec.instance_id);
1232: dbms_sql.column_value(p_get_pty_cursor_id, 3, x_party_rec.party_source_table);
1233: dbms_sql.column_value(p_get_pty_cursor_id, 4, x_party_rec.party_id);
1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);
1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);
1228: BEGIN
1229:
1230: dbms_sql.column_value(p_get_pty_cursor_id, 1, x_party_rec.instance_party_id);
1231: dbms_sql.column_value(p_get_pty_cursor_id, 2, x_party_rec.instance_id);
1232: dbms_sql.column_value(p_get_pty_cursor_id, 3, x_party_rec.party_source_table);
1233: dbms_sql.column_value(p_get_pty_cursor_id, 4, x_party_rec.party_id);
1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);
1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);
1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_id);
1229:
1230: dbms_sql.column_value(p_get_pty_cursor_id, 1, x_party_rec.instance_party_id);
1231: dbms_sql.column_value(p_get_pty_cursor_id, 2, x_party_rec.instance_id);
1232: dbms_sql.column_value(p_get_pty_cursor_id, 3, x_party_rec.party_source_table);
1233: dbms_sql.column_value(p_get_pty_cursor_id, 4, x_party_rec.party_id);
1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);
1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);
1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_id);
1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);
1230: dbms_sql.column_value(p_get_pty_cursor_id, 1, x_party_rec.instance_party_id);
1231: dbms_sql.column_value(p_get_pty_cursor_id, 2, x_party_rec.instance_id);
1232: dbms_sql.column_value(p_get_pty_cursor_id, 3, x_party_rec.party_source_table);
1233: dbms_sql.column_value(p_get_pty_cursor_id, 4, x_party_rec.party_id);
1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);
1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);
1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_id);
1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);
1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);
1231: dbms_sql.column_value(p_get_pty_cursor_id, 2, x_party_rec.instance_id);
1232: dbms_sql.column_value(p_get_pty_cursor_id, 3, x_party_rec.party_source_table);
1233: dbms_sql.column_value(p_get_pty_cursor_id, 4, x_party_rec.party_id);
1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);
1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);
1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_id);
1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);
1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);
1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);
1232: dbms_sql.column_value(p_get_pty_cursor_id, 3, x_party_rec.party_source_table);
1233: dbms_sql.column_value(p_get_pty_cursor_id, 4, x_party_rec.party_id);
1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);
1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);
1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_id);
1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);
1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);
1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);
1233: dbms_sql.column_value(p_get_pty_cursor_id, 4, x_party_rec.party_id);
1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);
1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);
1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_id);
1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);
1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);
1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);
1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);
1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);
1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);
1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_id);
1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);
1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);
1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);
1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);
1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);
1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);
1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_id);
1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);
1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);
1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);
1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);
1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);
1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);
1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_id);
1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);
1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);
1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);
1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);
1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);
1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);
1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);
1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);
1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);
1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);
1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);
1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);
1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);
1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);
1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);
1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);
1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);
1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);
1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);
1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);
1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);
1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);
1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);
1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);
1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);
1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);
1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);
1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);
1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);
1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);
1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);
1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);
1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);
1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);
1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);
1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);
1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);
1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);
1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);
1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);
1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);
1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);
1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);
1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);
1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);
1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);
1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);
1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);
1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);
1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);
1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);
1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);
1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);
1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);
1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);
1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);
1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);
1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);
1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);
1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);
1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);
1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);
1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);
1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);
1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);
1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);
1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);
1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);
1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);
1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);
1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);
1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);
1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);
1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);
1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);
1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);
1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);
1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);
1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);
1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);
1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);
1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);
1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);
1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);
1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);
1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);
1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);
1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);
1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);
1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);
1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);
1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);
1254: dbms_sql.column_value(p_get_pty_cursor_id, 25, x_party_rec.attribute15);
1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);
1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);
1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);
1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);
1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);
1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);
1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);
1254: dbms_sql.column_value(p_get_pty_cursor_id, 25, x_party_rec.attribute15);
1255: dbms_sql.column_value(p_get_pty_cursor_id, 26, x_party_rec.object_version_number);
1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);
1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);
1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);
1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);
1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);
1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);
1254: dbms_sql.column_value(p_get_pty_cursor_id, 25, x_party_rec.attribute15);
1255: dbms_sql.column_value(p_get_pty_cursor_id, 26, x_party_rec.object_version_number);
1256: dbms_sql.column_value(p_get_pty_cursor_id, 27, x_party_rec.primary_flag);
1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);
1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);
1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);
1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);
1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);
1254: dbms_sql.column_value(p_get_pty_cursor_id, 25, x_party_rec.attribute15);
1255: dbms_sql.column_value(p_get_pty_cursor_id, 26, x_party_rec.object_version_number);
1256: dbms_sql.column_value(p_get_pty_cursor_id, 27, x_party_rec.primary_flag);
1257: dbms_sql.column_value(p_get_pty_cursor_id, 28, x_party_rec.preferred_flag);
1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);
1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);
1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);
1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);
1254: dbms_sql.column_value(p_get_pty_cursor_id, 25, x_party_rec.attribute15);
1255: dbms_sql.column_value(p_get_pty_cursor_id, 26, x_party_rec.object_version_number);
1256: dbms_sql.column_value(p_get_pty_cursor_id, 27, x_party_rec.primary_flag);
1257: dbms_sql.column_value(p_get_pty_cursor_id, 28, x_party_rec.preferred_flag);
1258:
1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);
1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);
1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);
1254: dbms_sql.column_value(p_get_pty_cursor_id, 25, x_party_rec.attribute15);
1255: dbms_sql.column_value(p_get_pty_cursor_id, 26, x_party_rec.object_version_number);
1256: dbms_sql.column_value(p_get_pty_cursor_id, 27, x_party_rec.primary_flag);
1257: dbms_sql.column_value(p_get_pty_cursor_id, 28, x_party_rec.preferred_flag);
1258:
1259: END Get_Pty_Column_Values;
1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);
1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);
1254: dbms_sql.column_value(p_get_pty_cursor_id, 25, x_party_rec.attribute15);
1255: dbms_sql.column_value(p_get_pty_cursor_id, 26, x_party_rec.object_version_number);
1256: dbms_sql.column_value(p_get_pty_cursor_id, 27, x_party_rec.primary_flag);
1257: dbms_sql.column_value(p_get_pty_cursor_id, 28, x_party_rec.preferred_flag);
1258:
1259: END Get_Pty_Column_Values;
1260:
1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);
1254: dbms_sql.column_value(p_get_pty_cursor_id, 25, x_party_rec.attribute15);
1255: dbms_sql.column_value(p_get_pty_cursor_id, 26, x_party_rec.object_version_number);
1256: dbms_sql.column_value(p_get_pty_cursor_id, 27, x_party_rec.primary_flag);
1257: dbms_sql.column_value(p_get_pty_cursor_id, 28, x_party_rec.preferred_flag);
1258:
1259: END Get_Pty_Column_Values;
1260:
1261: /*----------------------------------------------------------*/
1270: ) IS
1271: l_party_rec csi_datastructures_pub.party_header_rec;
1272: BEGIN
1273:
1274: dbms_sql.define_column(p_get_pty_cursor_id, 1, l_party_rec.instance_party_id);
1275: dbms_sql.define_column(p_get_pty_cursor_id, 2, l_party_rec.instance_id);
1276: dbms_sql.define_column(p_get_pty_cursor_id, 3, l_party_rec.party_source_table ,30);
1277: dbms_sql.define_column(p_get_pty_cursor_id, 4, l_party_rec.party_id);
1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);
1271: l_party_rec csi_datastructures_pub.party_header_rec;
1272: BEGIN
1273:
1274: dbms_sql.define_column(p_get_pty_cursor_id, 1, l_party_rec.instance_party_id);
1275: dbms_sql.define_column(p_get_pty_cursor_id, 2, l_party_rec.instance_id);
1276: dbms_sql.define_column(p_get_pty_cursor_id, 3, l_party_rec.party_source_table ,30);
1277: dbms_sql.define_column(p_get_pty_cursor_id, 4, l_party_rec.party_id);
1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);
1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);
1272: BEGIN
1273:
1274: dbms_sql.define_column(p_get_pty_cursor_id, 1, l_party_rec.instance_party_id);
1275: dbms_sql.define_column(p_get_pty_cursor_id, 2, l_party_rec.instance_id);
1276: dbms_sql.define_column(p_get_pty_cursor_id, 3, l_party_rec.party_source_table ,30);
1277: dbms_sql.define_column(p_get_pty_cursor_id, 4, l_party_rec.party_id);
1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);
1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);
1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_id);
1273:
1274: dbms_sql.define_column(p_get_pty_cursor_id, 1, l_party_rec.instance_party_id);
1275: dbms_sql.define_column(p_get_pty_cursor_id, 2, l_party_rec.instance_id);
1276: dbms_sql.define_column(p_get_pty_cursor_id, 3, l_party_rec.party_source_table ,30);
1277: dbms_sql.define_column(p_get_pty_cursor_id, 4, l_party_rec.party_id);
1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);
1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);
1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_id);
1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);
1274: dbms_sql.define_column(p_get_pty_cursor_id, 1, l_party_rec.instance_party_id);
1275: dbms_sql.define_column(p_get_pty_cursor_id, 2, l_party_rec.instance_id);
1276: dbms_sql.define_column(p_get_pty_cursor_id, 3, l_party_rec.party_source_table ,30);
1277: dbms_sql.define_column(p_get_pty_cursor_id, 4, l_party_rec.party_id);
1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);
1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);
1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_id);
1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);
1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);
1275: dbms_sql.define_column(p_get_pty_cursor_id, 2, l_party_rec.instance_id);
1276: dbms_sql.define_column(p_get_pty_cursor_id, 3, l_party_rec.party_source_table ,30);
1277: dbms_sql.define_column(p_get_pty_cursor_id, 4, l_party_rec.party_id);
1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);
1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);
1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_id);
1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);
1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);
1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,30);
1276: dbms_sql.define_column(p_get_pty_cursor_id, 3, l_party_rec.party_source_table ,30);
1277: dbms_sql.define_column(p_get_pty_cursor_id, 4, l_party_rec.party_id);
1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);
1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);
1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_id);
1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);
1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);
1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,30);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);
1277: dbms_sql.define_column(p_get_pty_cursor_id, 4, l_party_rec.party_id);
1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);
1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);
1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_id);
1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);
1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);
1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,30);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);
1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,150);
1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);
1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);
1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_id);
1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);
1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);
1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,30);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);
1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,150);
1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,150);
1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);
1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_id);
1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);
1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);
1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,30);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);
1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,150);
1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,150);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);
1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_id);
1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);
1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);
1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,30);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);
1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,150);
1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,150);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);
1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,150);
1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);
1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);
1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,30);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);
1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,150);
1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,150);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);
1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,150);
1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,150);
1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);
1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,30);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);
1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,150);
1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,150);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);
1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,150);
1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,150);
1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,150);
1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,30);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);
1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,150);
1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,150);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);
1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,150);
1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,150);
1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,150);
1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,150);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);
1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,150);
1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,150);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);
1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,150);
1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,150);
1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,150);
1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,150);
1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,150);
1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,150);
1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,150);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);
1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,150);
1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,150);
1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,150);
1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,150);
1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,150);
1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,150);
1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,150);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);
1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,150);
1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,150);
1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,150);
1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,150);
1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,150);
1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,150);
1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,150);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);
1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,150);
1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,150);
1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,150);
1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,150);
1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,150);
1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,150);
1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,150);
1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,150);
1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,150);
1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,150);
1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,150);
1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,150);
1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,150);
1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,150);
1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,150);
1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,150);
1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,150);
1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,150);
1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,150);
1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,150);
1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,150);
1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,150);
1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,150);
1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,150);
1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,150);
1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,150);
1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,150);
1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,150);
1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,150);
1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,150);
1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,150);
1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,150);
1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,150);
1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,150);
1298: dbms_sql.define_column(p_get_pty_cursor_id, 25, l_party_rec.attribute15,150);
1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,150);
1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,150);
1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,150);
1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,150);
1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,150);
1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,150);
1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,150);
1298: dbms_sql.define_column(p_get_pty_cursor_id, 25, l_party_rec.attribute15,150);
1299: dbms_sql.define_column(p_get_pty_cursor_id, 26, l_party_rec.object_version_number);
1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,150);
1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,150);
1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,150);
1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,150);
1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,150);
1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,150);
1298: dbms_sql.define_column(p_get_pty_cursor_id, 25, l_party_rec.attribute15,150);
1299: dbms_sql.define_column(p_get_pty_cursor_id, 26, l_party_rec.object_version_number);
1300: dbms_sql.define_column(p_get_pty_cursor_id, 27, l_party_rec.primary_flag,1);
1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,150);
1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,150);
1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,150);
1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,150);
1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,150);
1298: dbms_sql.define_column(p_get_pty_cursor_id, 25, l_party_rec.attribute15,150);
1299: dbms_sql.define_column(p_get_pty_cursor_id, 26, l_party_rec.object_version_number);
1300: dbms_sql.define_column(p_get_pty_cursor_id, 27, l_party_rec.primary_flag,1);
1301: dbms_sql.define_column(p_get_pty_cursor_id, 28, l_party_rec.preferred_flag,1);
1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,150);
1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,150);
1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,150);
1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,150);
1298: dbms_sql.define_column(p_get_pty_cursor_id, 25, l_party_rec.attribute15,150);
1299: dbms_sql.define_column(p_get_pty_cursor_id, 26, l_party_rec.object_version_number);
1300: dbms_sql.define_column(p_get_pty_cursor_id, 27, l_party_rec.primary_flag,1);
1301: dbms_sql.define_column(p_get_pty_cursor_id, 28, l_party_rec.preferred_flag,1);
1302:
1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,150);
1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,150);
1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,150);
1298: dbms_sql.define_column(p_get_pty_cursor_id, 25, l_party_rec.attribute15,150);
1299: dbms_sql.define_column(p_get_pty_cursor_id, 26, l_party_rec.object_version_number);
1300: dbms_sql.define_column(p_get_pty_cursor_id, 27, l_party_rec.primary_flag,1);
1301: dbms_sql.define_column(p_get_pty_cursor_id, 28, l_party_rec.preferred_flag,1);
1302:
1303: END Define_Pty_Columns;
1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,150);
1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,150);
1298: dbms_sql.define_column(p_get_pty_cursor_id, 25, l_party_rec.attribute15,150);
1299: dbms_sql.define_column(p_get_pty_cursor_id, 26, l_party_rec.object_version_number);
1300: dbms_sql.define_column(p_get_pty_cursor_id, 27, l_party_rec.primary_flag,1);
1301: dbms_sql.define_column(p_get_pty_cursor_id, 28, l_party_rec.preferred_flag,1);
1302:
1303: END Define_Pty_Columns;
1304:
1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,150);
1298: dbms_sql.define_column(p_get_pty_cursor_id, 25, l_party_rec.attribute15,150);
1299: dbms_sql.define_column(p_get_pty_cursor_id, 26, l_party_rec.object_version_number);
1300: dbms_sql.define_column(p_get_pty_cursor_id, 27, l_party_rec.primary_flag,1);
1301: dbms_sql.define_column(p_get_pty_cursor_id, 28, l_party_rec.preferred_flag,1);
1302:
1303: END Define_Pty_Columns;
1304:
1305:
1318: BEGIN
1319:
1320: IF( (p_party_query_rec.instance_party_id IS NOT NULL)
1321: AND (p_party_query_rec.instance_party_id <> FND_API.G_MISS_NUM)) THEN
1322: DBMS_SQL.BIND_VARIABLE(p_cur_get_pty_rel, ':instance_party_id', p_party_query_rec.instance_party_id);
1323: END IF;
1324:
1325: IF( (p_party_query_rec.instance_id IS NOT NULL)
1326: AND (p_party_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
1323: END IF;
1324:
1325: IF( (p_party_query_rec.instance_id IS NOT NULL)
1326: AND (p_party_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
1327: DBMS_SQL.BIND_VARIABLE(p_cur_get_pty_rel, ':instance_id', p_party_query_rec.instance_id);
1328: END IF;
1329:
1330: IF( (p_party_query_rec.party_id IS NOT NULL)
1331: AND (p_party_query_rec.party_id <> FND_API.G_MISS_NUM)) THEN
1328: END IF;
1329:
1330: IF( (p_party_query_rec.party_id IS NOT NULL)
1331: AND (p_party_query_rec.party_id <> FND_API.G_MISS_NUM)) THEN
1332: DBMS_SQL.BIND_VARIABLE(p_cur_get_pty_rel, ':party_id', p_party_query_rec.party_id);
1333: END IF;
1334:
1335: IF( (p_party_query_rec.relationship_type_code IS NOT NULL)
1336: AND (p_party_query_rec.relationship_type_code <> FND_API.G_MISS_CHAR)) THEN
1333: END IF;
1334:
1335: IF( (p_party_query_rec.relationship_type_code IS NOT NULL)
1336: AND (p_party_query_rec.relationship_type_code <> FND_API.G_MISS_CHAR)) THEN
1337: DBMS_SQL.BIND_VARIABLE(p_cur_get_pty_rel, ':relationship_type_code', p_party_query_rec.relationship_type_code);
1338: END IF;
1339:
1340: END Bind_Pty_variable;
1341: