DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on DBMS_SQL

Line 569: dbms_sql.column_value(p_get_acct_cursor_id, 1, x_pty_acct_query_rec.ip_account_id);

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

Line 570: dbms_sql.column_value(p_get_acct_cursor_id, 2, x_pty_acct_query_rec.instance_party_id);

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

Line 571: dbms_sql.column_value(p_get_acct_cursor_id, 3, x_pty_acct_query_rec.party_account_id);

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

Line 572: dbms_sql.column_value(p_get_acct_cursor_id, 4, x_pty_acct_query_rec.relationship_type_code );

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

Line 573: dbms_sql.column_value(p_get_acct_cursor_id, 5, x_pty_acct_query_rec.active_start_date);

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

Line 574: dbms_sql.column_value(p_get_acct_cursor_id, 6, x_pty_acct_query_rec.active_end_date);

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

Line 575: dbms_sql.column_value(p_get_acct_cursor_id, 7, x_pty_acct_query_rec.context);

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

Line 576: dbms_sql.column_value(p_get_acct_cursor_id, 8, x_pty_acct_query_rec.attribute1);

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

Line 577: dbms_sql.column_value(p_get_acct_cursor_id, 9, x_pty_acct_query_rec.attribute2);

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

Line 578: dbms_sql.column_value(p_get_acct_cursor_id, 10, x_pty_acct_query_rec.attribute3);

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

Line 579: dbms_sql.column_value(p_get_acct_cursor_id, 11, x_pty_acct_query_rec.attribute4);

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

Line 580: dbms_sql.column_value(p_get_acct_cursor_id, 12, x_pty_acct_query_rec.attribute5);

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

Line 581: dbms_sql.column_value(p_get_acct_cursor_id, 13, x_pty_acct_query_rec.attribute6);

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

Line 582: dbms_sql.column_value(p_get_acct_cursor_id, 14, x_pty_acct_query_rec.attribute7);

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

Line 583: dbms_sql.column_value(p_get_acct_cursor_id, 15, x_pty_acct_query_rec.attribute8);

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

Line 584: dbms_sql.column_value(p_get_acct_cursor_id, 16, x_pty_acct_query_rec.attribute9);

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

Line 585: dbms_sql.column_value(p_get_acct_cursor_id, 17, x_pty_acct_query_rec.attribute10);

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

Line 586: dbms_sql.column_value(p_get_acct_cursor_id, 18, x_pty_acct_query_rec.attribute11);

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

Line 587: dbms_sql.column_value(p_get_acct_cursor_id, 19, x_pty_acct_query_rec.attribute12);

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

Line 588: dbms_sql.column_value(p_get_acct_cursor_id, 20, x_pty_acct_query_rec.attribute13);

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

Line 589: dbms_sql.column_value(p_get_acct_cursor_id, 21, x_pty_acct_query_rec.attribute14);

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

Line 590: dbms_sql.column_value(p_get_acct_cursor_id, 22, x_pty_acct_query_rec.attribute15);

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:

Line 591: dbms_sql.column_value(p_get_acct_cursor_id, 23, x_pty_acct_query_rec.object_version_number);

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;

Line 592: dbms_sql.column_value(p_get_acct_cursor_id, 24, x_pty_acct_query_rec.bill_to_address);

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:

Line 593: dbms_sql.column_value(p_get_acct_cursor_id, 25, x_pty_acct_query_rec.ship_to_address);

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: /*----------------------------------------------------------*/

Line 610: dbms_sql.define_column(p_get_acct_cursor_id, 1, l_party_acct_rec.ip_account_id);

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

Line 611: dbms_sql.define_column(p_get_acct_cursor_id, 2, l_party_acct_rec.instance_party_id);

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

Line 612: dbms_sql.define_column(p_get_acct_cursor_id, 3, l_party_acct_rec.party_account_id);

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

Line 613: dbms_sql.define_column(p_get_acct_cursor_id, 4, l_party_acct_rec.relationship_type_code ,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);

Line 614: dbms_sql.define_column(p_get_acct_cursor_id, 5, l_party_acct_rec.active_start_date);

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

Line 615: dbms_sql.define_column(p_get_acct_cursor_id, 6, l_party_acct_rec.active_end_date);

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

Line 616: dbms_sql.define_column(p_get_acct_cursor_id, 7, l_party_acct_rec.context,30);

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

Line 617: dbms_sql.define_column(p_get_acct_cursor_id, 8, l_party_acct_rec.attribute1,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);

Line 618: dbms_sql.define_column(p_get_acct_cursor_id, 9, l_party_acct_rec.attribute2,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);

Line 619: dbms_sql.define_column(p_get_acct_cursor_id, 10, l_party_acct_rec.attribute3,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);

Line 620: dbms_sql.define_column(p_get_acct_cursor_id, 11, l_party_acct_rec.attribute4,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);

Line 621: dbms_sql.define_column(p_get_acct_cursor_id, 12, l_party_acct_rec.attribute5,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);

Line 622: dbms_sql.define_column(p_get_acct_cursor_id, 13, l_party_acct_rec.attribute6,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);

Line 623: dbms_sql.define_column(p_get_acct_cursor_id, 14, l_party_acct_rec.attribute7,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);

Line 624: dbms_sql.define_column(p_get_acct_cursor_id, 15, l_party_acct_rec.attribute8,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);

Line 625: dbms_sql.define_column(p_get_acct_cursor_id, 16, l_party_acct_rec.attribute9,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);

Line 626: dbms_sql.define_column(p_get_acct_cursor_id, 17, l_party_acct_rec.attribute10,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);

Line 627: dbms_sql.define_column(p_get_acct_cursor_id, 18, l_party_acct_rec.attribute11,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);

Line 628: dbms_sql.define_column(p_get_acct_cursor_id, 19, l_party_acct_rec.attribute12,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);

Line 629: dbms_sql.define_column(p_get_acct_cursor_id, 20, l_party_acct_rec.attribute13,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);
633: dbms_sql.define_column(p_get_acct_cursor_id, 24, l_party_acct_rec.bill_to_address);

Line 630: dbms_sql.define_column(p_get_acct_cursor_id, 21, l_party_acct_rec.attribute14,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);
634: dbms_sql.define_column(p_get_acct_cursor_id, 25, l_party_acct_rec.ship_to_address);

Line 631: dbms_sql.define_column(p_get_acct_cursor_id, 22, l_party_acct_rec.attribute15,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);
635:

Line 632: dbms_sql.define_column(p_get_acct_cursor_id, 23, l_party_acct_rec.object_version_number);

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;

Line 633: dbms_sql.define_column(p_get_acct_cursor_id, 24, l_party_acct_rec.bill_to_address);

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:

Line 634: dbms_sql.define_column(p_get_acct_cursor_id, 25, l_party_acct_rec.ship_to_address);

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:

Line 654: DBMS_SQL.BIND_VARIABLE(p_get_acct_cursor_id, ':ip_account_id', p_pty_acct_query_rec.ip_account_id);

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

Line 659: DBMS_SQL.BIND_VARIABLE(p_get_acct_cursor_id, ':instance_party_id', p_pty_acct_query_rec.instance_party_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
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

Line 664: DBMS_SQL.BIND_VARIABLE(p_get_acct_cursor_id, ':party_account_id', p_pty_acct_query_rec.party_account_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
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

Line 669: DBMS_SQL.BIND_VARIABLE(p_get_acct_cursor_id, ':relationship_type_code', p_pty_acct_query_rec.relationship_type_code);

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:

Line 1230: dbms_sql.column_value(p_get_pty_cursor_id, 1, x_party_rec.instance_party_id);

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

Line 1231: dbms_sql.column_value(p_get_pty_cursor_id, 2, x_party_rec.instance_id);

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

Line 1232: dbms_sql.column_value(p_get_pty_cursor_id, 3, x_party_rec.party_source_table);

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

Line 1233: dbms_sql.column_value(p_get_pty_cursor_id, 4, x_party_rec.party_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);

Line 1234: dbms_sql.column_value(p_get_pty_cursor_id, 5, x_party_rec.relationship_type_code);

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

Line 1235: dbms_sql.column_value(p_get_pty_cursor_id, 6, x_party_rec.contact_flag);

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

Line 1236: dbms_sql.column_value(p_get_pty_cursor_id, 7, x_party_rec.contact_ip_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);
1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);

Line 1237: dbms_sql.column_value(p_get_pty_cursor_id, 8, x_party_rec.active_start_date);

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

Line 1238: dbms_sql.column_value(p_get_pty_cursor_id, 9, x_party_rec.active_end_date);

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

Line 1239: dbms_sql.column_value(p_get_pty_cursor_id, 10, x_party_rec.context);

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

Line 1240: dbms_sql.column_value(p_get_pty_cursor_id, 11, x_party_rec.attribute1);

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

Line 1241: dbms_sql.column_value(p_get_pty_cursor_id, 12, x_party_rec.attribute2);

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

Line 1242: dbms_sql.column_value(p_get_pty_cursor_id, 13, x_party_rec.attribute3);

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

Line 1243: dbms_sql.column_value(p_get_pty_cursor_id, 14, x_party_rec.attribute4);

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

Line 1244: dbms_sql.column_value(p_get_pty_cursor_id, 15, x_party_rec.attribute5);

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

Line 1245: dbms_sql.column_value(p_get_pty_cursor_id, 16, x_party_rec.attribute6);

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

Line 1246: dbms_sql.column_value(p_get_pty_cursor_id, 17, x_party_rec.attribute7);

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

Line 1247: dbms_sql.column_value(p_get_pty_cursor_id, 18, x_party_rec.attribute8);

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

Line 1248: dbms_sql.column_value(p_get_pty_cursor_id, 19, x_party_rec.attribute9);

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

Line 1249: dbms_sql.column_value(p_get_pty_cursor_id, 20, x_party_rec.attribute10);

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

Line 1250: dbms_sql.column_value(p_get_pty_cursor_id, 21, x_party_rec.attribute11);

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

Line 1251: dbms_sql.column_value(p_get_pty_cursor_id, 22, x_party_rec.attribute12);

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

Line 1252: dbms_sql.column_value(p_get_pty_cursor_id, 23, x_party_rec.attribute13);

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

Line 1253: dbms_sql.column_value(p_get_pty_cursor_id, 24, x_party_rec.attribute14);

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

Line 1254: dbms_sql.column_value(p_get_pty_cursor_id, 25, x_party_rec.attribute15);

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:

Line 1255: dbms_sql.column_value(p_get_pty_cursor_id, 26, x_party_rec.object_version_number);

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;

Line 1256: dbms_sql.column_value(p_get_pty_cursor_id, 27, x_party_rec.primary_flag);

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:

Line 1257: dbms_sql.column_value(p_get_pty_cursor_id, 28, x_party_rec.preferred_flag);

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: /*----------------------------------------------------------*/

Line 1274: dbms_sql.define_column(p_get_pty_cursor_id, 1, l_party_rec.instance_party_id);

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

Line 1275: dbms_sql.define_column(p_get_pty_cursor_id, 2, l_party_rec.instance_id);

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

Line 1276: dbms_sql.define_column(p_get_pty_cursor_id, 3, l_party_rec.party_source_table ,30);

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

Line 1277: dbms_sql.define_column(p_get_pty_cursor_id, 4, l_party_rec.party_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);

Line 1278: dbms_sql.define_column(p_get_pty_cursor_id, 5, l_party_rec.relationship_type_code ,30);

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

Line 1279: dbms_sql.define_column(p_get_pty_cursor_id, 6, l_party_rec.contact_flag,1);

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

Line 1280: dbms_sql.define_column(p_get_pty_cursor_id, 7, l_party_rec.contact_ip_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);
1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,150);

Line 1281: dbms_sql.define_column(p_get_pty_cursor_id, 8, l_party_rec.active_start_date);

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

Line 1282: dbms_sql.define_column(p_get_pty_cursor_id, 9, l_party_rec.active_end_date);

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

Line 1283: dbms_sql.define_column(p_get_pty_cursor_id, 10, l_party_rec.context,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);
1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,150);

Line 1284: dbms_sql.define_column(p_get_pty_cursor_id, 11, l_party_rec.attribute1,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);

Line 1285: dbms_sql.define_column(p_get_pty_cursor_id, 12, l_party_rec.attribute2,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);

Line 1286: dbms_sql.define_column(p_get_pty_cursor_id, 13, l_party_rec.attribute3,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);

Line 1287: dbms_sql.define_column(p_get_pty_cursor_id, 14, l_party_rec.attribute4,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);

Line 1288: dbms_sql.define_column(p_get_pty_cursor_id, 15, l_party_rec.attribute5,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);

Line 1289: dbms_sql.define_column(p_get_pty_cursor_id, 16, l_party_rec.attribute6,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);

Line 1290: dbms_sql.define_column(p_get_pty_cursor_id, 17, l_party_rec.attribute7,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);

Line 1291: dbms_sql.define_column(p_get_pty_cursor_id, 18, l_party_rec.attribute8,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);

Line 1292: dbms_sql.define_column(p_get_pty_cursor_id, 19, l_party_rec.attribute9,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);

Line 1293: dbms_sql.define_column(p_get_pty_cursor_id, 20, l_party_rec.attribute10,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);

Line 1294: dbms_sql.define_column(p_get_pty_cursor_id, 21, l_party_rec.attribute11,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);

Line 1295: dbms_sql.define_column(p_get_pty_cursor_id, 22, l_party_rec.attribute12,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);

Line 1296: dbms_sql.define_column(p_get_pty_cursor_id, 23, l_party_rec.attribute13,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);
1300: dbms_sql.define_column(p_get_pty_cursor_id, 27, l_party_rec.primary_flag,1);

Line 1297: dbms_sql.define_column(p_get_pty_cursor_id, 24, l_party_rec.attribute14,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);
1301: dbms_sql.define_column(p_get_pty_cursor_id, 28, l_party_rec.preferred_flag,1);

Line 1298: dbms_sql.define_column(p_get_pty_cursor_id, 25, l_party_rec.attribute15,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);
1302:

Line 1299: dbms_sql.define_column(p_get_pty_cursor_id, 26, l_party_rec.object_version_number);

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;

Line 1300: dbms_sql.define_column(p_get_pty_cursor_id, 27, l_party_rec.primary_flag,1);

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:

Line 1301: dbms_sql.define_column(p_get_pty_cursor_id, 28, l_party_rec.preferred_flag,1);

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:

Line 1322: DBMS_SQL.BIND_VARIABLE(p_cur_get_pty_rel, ':instance_party_id', p_party_query_rec.instance_party_id);

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

Line 1327: DBMS_SQL.BIND_VARIABLE(p_cur_get_pty_rel, ':instance_id', p_party_query_rec.instance_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
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

Line 1332: DBMS_SQL.BIND_VARIABLE(p_cur_get_pty_rel, ':party_id', p_party_query_rec.party_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
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

Line 1337: DBMS_SQL.BIND_VARIABLE(p_cur_get_pty_rel, ':relationship_type_code', p_party_query_rec.relationship_type_code);

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: